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

Automation: Send to contacts in a cell
I'm building an automation to send a reminder to contacts in a cell but it doesn't let select the cell with a dropdown. Is there a workaround?
What happens to sheet workflows when the creator is deactivated?
We have multiple sheets with automation/alert workflows, and the person who created those workflows has left the company. We need to deactivate her account and reassign her license. Will the workflows she built still run? I believe an admin or sheet owner can edit others' workflows, but if we do nothing, will her workflows…
Browse tap disappear how can I bring it back
Hi there, For one of my folder the browse tab disappears when I click in one of the pages for a particular work spaces, but It does no other work spaces. what can i do so it shows on the page again

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