Trying to trigger a flag to turn red once the project status column has changed
Have a Flag column named Outstanding Balance. I would like to have the flag trigger red if the project status column (which is a drop down) is changed to Invoiced or partial payment received.
I have tried various formulas, but it keeps coming up with #unparseable.
Any help would be appreciated.
Thanks
Best Answer
-
Try this:
=IF(AND(Awarded@row = "Yes", [Project Status]@row <> "100% Paid - Good to Close"), 1)
Answers
-
Hi @dmorettin ,
Try this. =IF(OR([Project Status]@row = "Invoiced", [Project Status]@row = "Partial Payment Received"), 1)
Hope this helps,
Dave
-
I have tried this one already and could not get it to work.
If there is conditional formating that changes the entire row to a color, would this affect the formula?
Thanks,
David
-
Hi dmorettin,
Please try the following formula -
=IF(OR([Project Status]@row = "Invoiced", [Project Status]@row = "Partial Payment Received"), 1, 0)
Thank you,
Shubham Umale
Associate - Smartsheet, Ignatiuz Software
-
Thank you that worked.
Now they want to change it. They want the flag triggered on "red" when the Awarded column drop down is changed to "yes" and then triggered to off "not red" when the Project Status column drop down is changed to "100% Paid - Good to Close"
-
Try this:
=IF(AND(Awarded@row = "Yes", [Project Status]@row <> "100% Paid - Good to Close"), 1)
-
Hi Paul,
That worked great.
Thank you!
-
Happy to help. 👍️
-
@HarryS You should be able to just use a Conditional Formatting rule for this.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!