IF statement for when boxes are checked

heatherfeather

Hi! I am a SS newbie and can't figure out what is probably a very simple formula. I am needing my Project Status to change to "Design" when the ALTA Survey Completion is checked actual and/or when the As Built Received Actual is Checked.

bisaacs

Hey @heatherfeather,

For checkboxes, they use 1 and 0 to determine if checked or unchecked, respectively. To do what you're trying to do, you'd want a formula like this in the Project Status Column:

=IFERROR(IF((OR([ALTA Survey Completion]@row = 1, [As Built Received Actual]@row = 1),"Design"), "")

Hope this helps!

bisaacs

Hey @heatherfeather,

For checkboxes, they use 1 and 0 to determine if checked or unchecked, respectively. To do what you're trying to do, you'd want a formula like this in the Project Status Column:

=IFERROR(IF((OR([ALTA Survey Completion]@row = 1, [As Built Received Actual]@row = 1),"Design"), "")

Hope this helps!

heatherfeather

Thank you! Is there a limit on the number of IF's I can use in one cell?