Looking to get some insight on a formula

Bwoods113

submittal formula.JPG

Trying to write a formula so that if A is no then B would be complete and if A is yes then it would be Not Started, I would still need to have the functionality of the drop downs for people to use. Cant seem to find the best way to do this. Any help is greatly appreciated.

Andrée Starå

Hi @Bwoods113,

I hope you're well and safe!

Try something like this.

=IF([Assigned To]63 = "Yes", "Not Started", "Complete")

Did that work/help?

I hope that helps!

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!

Bwoods113

=IF([Assigned To]63 = Yes, "Not Started", "Complete")

This is what I was thinking but it doesn't work.

Andrée Starå

Hi @Bwoods113,

I hope you're well and safe!

Try something like this.

=IF([Assigned To]63 = "Yes", "Not Started", "Complete")

Did that work/help?

I hope that helps!

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!