If statement help.

dminor764

I have two columns I am using in my smartsheet, "responsible" and "assigned to" I need a formula that will display the "responsible" only if the "assigned to" is blank, and if not it will display the "assigned to". I have tried to write and IF statement but cannot get to work. Any help would be appreciated.

Carson Penticuff

Try this:

=IF(ISBLANK([assigned to]@row), [responsible]@row, [assigned to]@row)

SteyJ

=IF(ISBLANK([Assigned to]@row), Responsible@row, [Assigned to]@row)

Hope this helps!

Carson Penticuff

Try this:

=IF(ISBLANK([assigned to]@row), [responsible]@row, [assigned to]@row)

SteyJ

=IF(ISBLANK([Assigned to]@row), Responsible@row, [Assigned to]@row)

Hope this helps!

dminor764

Perfect! Thank you!

Andrée Starå

Hi @dminor764

I hope you're well and safe!

To add to the previous commenter's excellent advice/answer.

Here's another option. This is the one I prefer because it's shorter.

=IF([Assigned to]@row = "", Responsible@row, [Assigned to]@row)

You could also reverse it.

=IF([Assigned to]@row <> "", [Assigned to]@row, Responsible@row)

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!