IF Formula Help

Silvia Rangel

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!

Jayesh Nathani

Hi,

Try below:

=IF([Job Status]@row = "As-Built Submitted", 1, 0)

Andrée Starå

@srangel Glad you got it working!

Andrée Starå

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

Jayesh Nathani

Hi,

Try below:

=IF([Job Status]@row = "As-Built Submitted", 1, 0)

Silvia Rangel

@Jayesh Nathani

Yes! After playing with it (a lot) more l got to that formula as well! Thanks!

Andrée Starå

@srangel Glad you got it working!

Silvia Rangel

@Jayesh Nathani

Yes! After playing with it (a lot) more l got to that formula as well! Thanks!