If Complete box is checked can multiple check box columns be AUTO checked?
I have a complete column with a check box - and several additional action items needed for each row. Many times multiple things happen at once...
IF the complete box is checked can ALL columns with check boxes be AUTO checked also????
Best Answers
-
You can add a formula to the other check box columns that's =if([Complete]@row=1,1)
Just change the "Complete" thats in these brackets to whatever the name of your column is for the complete column.
You will still be able to check off the non-complete check boxes manually - when you check it off manually the formula will go away.
Maddie
-
Thank you!! I was making it too difficult, trying to do them all... LOL That was too easy... LOL
Answers
-
You can add a formula to the other check box columns that's =if([Complete]@row=1,1)
Just change the "Complete" thats in these brackets to whatever the name of your column is for the complete column.
You will still be able to check off the non-complete check boxes manually - when you check it off manually the formula will go away.
Maddie
-
Thank you!! I was making it too difficult, trying to do them all... LOL That was too easy... LOL
-
happy to help!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!