IF Formula
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?
Answers
-
Try this one ...
=IF(Date@row = "", "", IF([Checkbox 1]@row = true, IF([Checkbox 2]@row = true, Date@row + 5, "")))
Hope this helps!
Heath Hilton
-
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
Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages
If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!
-
I misread your request, Jeff Reisman got it though.
Hope this helps!
Heath Hilton
-
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")
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Hi Everyone, I would like to create a weekly trivia game for my team members and my thought was to use a form to populate answers to the sheet. However, I don't want them to be able to see what other …
- Good afternoon, In reviewing the question that Nino Chkhikvadze posted on 7/30/20, and the response from Andree Stara, Community Champion, on the same date, would it be accurate to say that an unlicen…
