I have a SS formula question. New on this platform - how do I connect and share?

DP_SS23

=IF(AND ([Risk description]@row = ""), (Status@row >= "Open - Mitigation Plan", Status@row = "Open - No Mitigation Plan", "Open", "Closed"))

Spot the issue?

Andrée Starå

@DP_SS23

Excellent!

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!

Andrée Starå

Hi @DP_SS23

I hope you're well and safe!

What do you want the formula to do?

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅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!

DP_SS23

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

Andrée Starå

@DP_SS23

Try something like this.

=IF([Risk description]@row <> "", IF(Status@row <> "", "Closed", "Open"))

Did it work?

✅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!

DP_SS23

Example:

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

DP_SS23

I have solved this formula. Thanks for your help Andrée

Andrée Starå

@DP_SS23

Excellent!

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!