Multiple IF condition

Leod13

Leod13 ✭

08/28/24 in Smartsheet Basics

I'm trying to create an IF condition

if column B is <> to standby, the answer is Active

IF Column B is = to standby, the answer is offline

0 ·

Best Answer

jmyzk_cloudsmart_jp ✭✭✭✭✭✭

08/28/24 edited 08/28/24 Answer ✓

Hi
=IF(B@row = "standby", "offline", "Active")

0 · Share on Facebook Share on Twitter

Answers

jmyzk_cloudsmart_jp ✭✭✭✭✭✭

08/28/24 edited 08/28/24 Answer ✓

Hi
=IF(B@row = "standby", "offline", "Active")

0 · Share on Facebook Share on Twitter
Leod13 ✭

09/05/24

it works thanks

0 · Share on Facebook Share on Twitter
jmyzk_cloudsmart_jp ✭✭✭✭✭✭

09/06/24

Happy to help!😁

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

AI icon disappeared
I noticed the AI icon disappeared and I am unable to use AI in my sheets.
Why am I not getting a workflow notification email when I trigger the action?
A notification is triggered when I or one other person enters a date in a field. When the other person enters the date, we both receive the notification email; however, when I enter the date, the other person receives the email, but I do not. The other person is the owner, I am an admin if that makes any difference.
Can licensed users from other companies input into our company smartsheets?
As before, we are moving our licensing over to the new plan and we share our sheets with our customer. Many thanks! Jo

Help shape the future of Smartsheet.
Share your ideas and feature requests.