=IF(AND ([Risk description]@row = ""), (Status@row >= "Open - Mitigation Plan", Status@row = "Open - No Mitigation Plan", "Open", "Closed"))
Spot the issue?
You're more than welcome!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
I hope you're well and safe!
What do you want the formula to do?
Be safe, and have a fantastic week!
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
If the row has a description and if the status has if there is has is not blank i.e. has "Open - Mitigation Plan" or Status@row = "Open - No Mitigation, then return "open" else "closed". If no description, then there should be no return i.e. blank.
Hope this makes sense
Try something like this.
=IF([Risk description]@row <> "", IF(Status@row <> "", "Closed", "Open"))
Did it work?
Description = Car
Status = Open - 2 seater, Open - 4 seater
Status = Closed - 2 seater, Closed - 4 seater, Closed - 7 seater
The formula required
- if the description is NOT blank and if the status is Open - 2 seater, Open - 4 seater
- Result should be "open"
if the description is NOT blank and if the status is Closed - 2 seater, Closed - 4 seater, Closed - 7 seater"
- Result should be "closed"
Otherwise, if no description result should be NIL (blank)
Hope this helps
I have solved this formula. Thanks for your help Andrée
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.