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
Best Answer
-
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.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
Answers
-
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.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
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?
-
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.
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Thank you so much Jeff!
-
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!
-
@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
Regards,
Jeff Reisman
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
Worked like a charm, thanks Jeff!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!