I’m trying to make a function in calc that prints the row number of a cell. I tried creating the sequence:
=IF(U4="",4,"")
=IF(U4="",5,"")
=IF(U4="",6,"")
=IF(U4="",7,"")
and then dragging the formula downwards, but it just cycles 4 5 6 7 4 5 6 7.