# IF Formula

Options

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?

• Options

Try this one ...

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

Hope this helps!

Heath Hilton

• ✭✭✭✭✭✭
edited 01/05/22
Options

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)

Regards,

Jeff Reisman

If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

• Options

Hope this helps!

Heath Hilton

• Options

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")

• ✭✭✭✭✭✭
Options

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!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.