Help with IF/ Then Formula Based on Number of Rows


Hey Guys,

I want to create a formula that will return a statement when a number of certain number of rows is reached.

I have a unique cell that has a number let's say 10, and I created a helper column (Row ID) that will simply designate each row by a number. I want to create an automatic statement in another cell that will alert a customer when they create 10 rows.

I tried creating my own IF formula but It's not working.

Can someone guide me with the correct formula?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!