IF Formula Help
Hello,
I am trying to write a formula that checks the box when a condition is met. In this case, when the Job Status is marked as As-Built Submitted I want the check box to automatically be marked. Please note the Job Status column is a drop down:
Thanks!
Best Answers
-
Hi,
Try below:
=IF([Job Status]@row = "As-Built Submitted", 1, 0)
-
@srangel Glad you got it working!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Hi,
Is everything in one sheet or in two different ones?
I hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hi,
Try below:
=IF([Job Status]@row = "As-Built Submitted", 1, 0)
-
Yes! After playing with it (a lot) more l got to that formula as well! Thanks!
-
@srangel Glad you got it working!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Yes! After playing with it (a lot) more l got to that formula as well! Thanks!
Help Article Resources
Categories
Check out the Formula Handbook template!