How do I create an IF formula with checkbox?

Phoebe_S
✭✭
Hi there!
I'm trying to create a formula using a checkbox and I'm really struggling. Using the parameters below, can anyone help me with the formula?
Column 1 = Australian states/jurisdictions (SA, WA, etc)
Column 2 = Complete column with checkbox
PROBLEM: If Column 2 is checked in Row 1, I want Column 1 in Row 2 to automatically populate with 'SA'
Any assistance would be greatly appreciated!
Thanks,
Phoebs
Tags:
Comments
-
Try puting the formula below in Row 2 Column 1, Where Column 2 = Complete and is a status box.
FYI - A checked status box has a value of 1 and unchecked status box has a value of 0 when calculating values in IF statements
=IF(Complete1 = 1, "SA", " ")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67K Get Help
- 441 Global Discussions
- 154 Industry Talk
- 502 Announcements
- 5.4K Ideas & Feature Requests
- 85 Brandfolder
- 156 Just for fun
- 79 Community Job Board
- 512 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!