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?
https://us.v-cdn.net/6031209/uploads/3XSD5BLGA2LJ/symbol-flag-png.png
How to auto-trigger a flag in smartsheet?
Emi
✭✭
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
- 66.6K Get Help
- 435 Global Discussions
- 152 Industry Talk
- 495 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I am working in a separate sheet for calculating metrics. I want to count the number of items in a referenced date range in another sheet that meet certain year criteria. For example, I want to find t…
- I have a column that is a contact list where a single or multiple staff members can be selected to be scheduled. I'm trying to create a formula that counts how many times each individual's names are l…
- I have two columns I am using for this formula: "Date Received" and "Days Duration (Received to Listed)". I want the formula below to look at any items in the Date Received column between 1/1/25 and 1…