What is the formula to check box from value in another column?

KD_HUM

KD_HUM ✭

01/16/23 in Smartsheet Basics

I have a checkbox column that I want to automatically 'check' when another column's status is either 'N/A' or 'Complete'.

0 ·

Best Answer

Ryan Sides ✭✭✭✭✭✭

01/16/23 Answer ✓

=if(Or(Column@row = "N/A", Column@row = "Complete"), 1, 0)

Like that?

Ryan Sides
Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube
Come Say Hello!
1 · Share on Facebook Share on Twitter

Answers

Ryan Sides ✭✭✭✭✭✭

01/16/23 Answer ✓

=if(Or(Column@row = "N/A", Column@row = "Complete"), 1, 0)

Like that?

Ryan Sides
Smartsheet Tips and Tricks for Beginners and Advanced on LinkedIn and YouTube
Come Say Hello!
1 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Fairly new to Smartsheets - Having trouble with a countifs / date formula. Need your help!
I have a "master data" sheet that has a "DATE OF INCIDENT" field column, and a "FOUND ON A SCHEDULED INSPECTION" field column that populated as either yes or no. These are the two references I'll want to use in my formula on my metrics sheet. In my metrics sheet I want to use a COUNTIFS statement to tell me how many passed…
A workflow has become invalid
Hi, I received an email saying that one of the workflows of a particular sheet has been deactivated. The action for this workflow is so simple, so when the column in another sheet is changed as "completed" the row is copied and moved to a master sheet. It is important to mention that we have been using this for months and…
Permissions Workspace vs Sheet
I want to set a Workspace permission for all members (except Owner and 1 Admin) to Editor - Can Share, which I'm able to do. Within that workspace are some files that I want some of the members to have Admin permission, but still only have Editor permission for the other files in the Workspace. When I open the sheet for…

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