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?

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

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])

All comments

Paul Newcome

You would use somethign like this:

=IF(MAX([Row ID]:[Row ID]) >= [Cell Reference For Limit]row#, "output when true")

danilo

https://community.smartsheet.com/discussion/comment/355561#Comment_355561

This worked beautifully! Thank you, Paul :)

danilo

@Paul Newcome

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?

Paul Newcome

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])

danilo

Much appreciated, Paul!

Paul Newcome

Happy to help. 👍️

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.