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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!