Formula to detect if cell is at row 1

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.



  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    edited 12/26/20

    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.


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!