IF Formula

Sidonia Posteuca

I am trying to set up a formula that sets a date column 5 days ahead of another date column if either checkbox column is checked (there are two checkbox columns).

Any ideas?

Heath Hilton

Sidonia Posteuca,

Try this one ...

=IF(Date@row = "", "", IF([Checkbox 1]@row = true, IF([Checkbox 2]@row = true, Date@row + 5, "")))

Jeff Reisman

In your second Date column, use the OR function within an IF statement:

=IF(OR([CheckboxA]@row = 1, [CheckboxB]@row = 1), DateA@row+5, "")

in English, if either checkbox is checked, add 5 days to the value from DateA column, otherwise, leave it blank.

(Edited for syntax after trying it myself, LOL)

Heath Hilton

Sidonia Posteuca,

I misread your request, Jeff Reisman got it though.

I have questions

Could anyone tell me what's wrong with these forumla? Why is it saying incorrect argument set? This formula worked on other sheets. Thanks

=IF(OR(Status18 = "In Progress", Status19 = "In Progress", Status20 = "In Progress", Status21 = "In Progress", Status22 = "In Progress", Status23 = "In Progress", Status24= "In Progress", Status25 = "In Progress", "In Progress")

Andrée Starå

Hi @I have questions

I hope you're well and safe!

Try something like this.

=IF(OR(Status18 = "In Progress", Status19 = "In Progress", Status20 = "In Progress", Status21 = "In Progress", Status22 = "In Progress", Status23 = "In Progress", Status24= "In Progress", Status25 = "In Progress"), "In Progress")

Did that work/help?

I hope that helps!

Have a fantastic week & Happy New Year!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!