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
-
Yes. You would use a basic subtraction where you subtract the MAX from the set number.
=[Cell Reference For Limit]row# - MAX([Row ID]:[Row ID])
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
You would use somethign like this:
=IF(MAX([Row ID]:[Row ID]) >= [Cell Reference For Limit]row#, "output when true")
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
This worked beautifully! Thank you, Paul :)
-
The above equation worked smoothly, but it made me wonder if it would also be possible to create a formula that would calculate the number of rows remaining for the client to use the smart sheet
Example: 10 rows maximum
as the user inputs 1 row, the formula would calculate a number as 9
two rows total, then 8.
Would something like that also be possible?
-
Yes. You would use a basic subtraction where you subtract the MAX from the set number.
=[Cell Reference For Limit]row# - MAX([Row ID]:[Row ID])
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Much appreciated, Paul!
-
Happy to help. 👍️
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!