How do I set a condition based on range of difference between dates?
I am trying to set an action based on the range of difference between dates. If the END DATE is 5 DAYS OR MORE than the START DATE, take an action.
Answers
-
Are you trying to set up an automation or have a formula create an output on the sheet?
-
I have a single sheet, multiple rows. Each row is an event. I display the events in calendar format. I want to change the colour of the whole line when an end date is 5 days more than a start date.
-
I hope you're well and safe!
Add a so-called helper column which we'll use to check the difference in days between the dates.
Something like this. (can be converted to a Column Formula)
=[End Date]@row - [Start Date]@row
The next step would be to set up the Conditional Formatting Rule to check for the number of days in that column.
Make sense?
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
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, Awesome, 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.
-
Thank you for this. I understand the logic here. I do not know how to enter this formula. I have only used the conditional formatting dropdown, where I select fields and arguments. Where/how do I enter a free-form formula? Thanks again.
-
You would enter the formula into a new column.
-
I am sorry. Not getting this. Where do I enter the formula. I can't enter it within the conditional formatting dropdown. Do I enter it as data in the column?
-
Never mind. Figured it out. And it works. Thank you.
-
Happy to help. 👍️
-
Excellent!
Happy to help!
✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome 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
- Smartsheet Customer Resources
- 63.5K Get Help
- 402 Global Discussions
- 213 Industry Talk
- 450 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 135 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives