Help with IF/ Then Formula Based on Number of Rows

Options

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?

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!