Formula to detect if cell is at row 1

Joshua Rudesill

I have been looking through the forum and documentation to see if smart sheets is capable of this, but I can't find any support thus far so hopefully this hasn't been answered. I am currently attempting to create a daily task sheet that refreshes at the beginning of a new day to prompt form submission.

The sheet would work by using two columns the first column contains the formula =IF(Created@row = TODAY(0), 1, 0) which just checks a box if the submission was entered today. Conditional formatting is then used to color the primary column green, or red if the submission was entered any day prior to today's date.

The second column ideally would then be a simple binary. If the cell is at row 1 then it is checked, otherwise, it isn't. I haven't been able to figure out a good formula to achieve this, so any guidance or input would be helpful.

Thanks!

Mark Cronk

Hi @Joshua Rudesill ,

Not sure it's the best way, but if you have a column with a unique value in each row you could use: =IF([unique]1=[unique]@row, 1, 0) in your checkbox column.

Good luck.

Mark