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

How do you update an existing users email address due to a last name change?
Hello, I'm a system admin and I've run into something new and I haven't been successful in finding an answer to. I have an existing user who recently got married and changed her last name. Her email address has been updated in our systems to reflect the name change. Example: Jane.Doe@company.com to Jane.Smith@company.com I…
how can I search for a sheet and exclude certain workspaces in the search?
how can I search for a sheet and exclude certain workspaces in the search?
Restrictions on "Clear Cells" automation?
I want to set up a rule to have a cell contents cleared when the completed date is filled in another cell. I have used similar automation in the past, but when I try this time is does not give me the column of the cell I want to clear as an option to choose when setting up the rule. Are there restrictions on the cell type…

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