How to auto-trigger a flag in smartsheet?

Hi All,

I am relatively new to smartsheet and trying to see if I can auto-trigger a flag in smartsheet?

For example, if the quantity is under 500, the flag will automatically turn red. Is there a formula or a way to do this? Another question, if the quantity wasn't in the same sheet that the flag was at, can I still trigger the flag by linking to another sheet cell?

Thank you

Find more posts tagged with

Accepted answers

Jeff Reisman

https://community.smartsheet.com/discussion/comment/317331#Comment_317331

Yes, sorry, I was thinking of the RYG ball symbol. Flag columns are just like checkbox columns: 1 = red flag, 0 = white flag. With this formula in your flag column,

=IF(Quantity@row <500, 1, 0)

rows with quantity under 500 will show a red flag.

All comments

Jeff Reisman

Yes, yes, and yes.

For a value in the same sheet on same row:

=IF(Quantity@row <500, "Red", "Green")

A cell in another sheet: As you begin typing your formula, Smartsheet will pop up a helper screen. Click on Reference Another Sheet, and select the quantity cell. Smartsheet will show your remote cell in curly brackets.

=IF({Remote Quantity Cell} <500, "Red", "Green")

If you give us some more details about what you're trying to flag, I can offer additional guidance.

Emi

Hi Jeff,

Thank you so much for this quick answer. it works good with the formula. However, instead of red and green text, is there a way to turn the symbol flag to red?

Jeff Reisman

https://community.smartsheet.com/discussion/comment/317331#Comment_317331

Yes, sorry, I was thinking of the RYG ball symbol. Flag columns are just like checkbox columns: 1 = red flag, 0 = white flag. With this formula in your flag column,

=IF(Quantity@row <500, 1, 0)

rows with quantity under 500 will show a red flag.

Emi

Thank you so much Jeff!

LaurGrad

Hello! I am very simply trying to automate the flag column to turn red when the severance column next to it populates with a yes. What is the easiest way to do this? TIA!

Jeff Reisman

@LaurGrad Similar to the formula above, use an IF function in the Flag column:

=IF([Severance?]@row = "Yes", 1, 0)

Here's more info about the IF function: https://help.smartsheet.com/function/if

LaurGrad

Worked like a charm, thanks Jeff!!

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.