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

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

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

Save and Refresh with multiple users
I use SS to obtain information from many people who respond to my requests, which are sent out en masse. If I make a change to the SS and save it without first refreshing it, are recent responses that I didn't yet see saved or overwritten by what I see in the sheet I'm saving?
Looking for Guidance on Smartsheet Aligned Solution Professional Certification
Hi everyone, I have experience using Smartsheet Core Product and I'm Core Product Certified , but I am new to Smartsheet Control Center (SCC). I am currently preparing for the Smartsheet Aligned Solution Professional Certification and would love to hear insights from those who have taken it before. Has anyone taken the…
Conversations in Sheet vs Report (for the Sheet)
Hello Team, May be this is intentional, but want to double check. In a sheet, when i open the conversations window, I am able to see tabs for "Row", "Sheet" "All" and "Unread". On the contrary, in a report created for a particular sheet, I am only able to see the comments at a row level (the only and default option) - is…

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