Multiple IF condition

Options

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 Community Champion

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 Community Champion

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 Community Champion

09/06/24

Happy to help!😁

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

What activities require paid membership for external partners?
If external users are sheet/report/workspace owners, are they required to be paid members? We have 5 or 6 partners who have created/own items and I am assuming they have to be paid members if they own items in our account.
What is the difference between a workspace and a sheet?
I have noticed that we can no longer just create a sheet.
I have given admin access to 2 users but they cant access locked cells. am i missing something?
Hi everyone, this is the first time i have needed to post a question. i have been using Smartsheet for about a year and have developed the environment to suit our business quite easily, now i have it running i have set up all of the users (previously everyone was using the 1 login while i set it up). However now i have an…

woman with hands out and open

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

Watch video<