Notifications
Clear all
Dashboards & Charts
2
Posts
2
Users
0
Reactions
102
Views
Topic starter
Thanks for sharing the video.
On the conditional format calendar, I want to make a change.
Instead of having a single date per cell, I grouped them into ranges. For example: 13th-17th, 20th-24th and so forth.
Any ideas on how to setup the same conditional format of the video but working with date ranges instead of single dates? Example: if I have a task in progress from the 14th through the 16th, I want green-colored the 13-17 cell.
I hope you can help
Posted : 11/05/2024 12:46 pm
Hi Emmanuel,
Those are not date ranges, 13-17 is a text considered a date range. I would insert 2 hidden rows above that "date range" with the real date ranges: 13/05/2024 and 17/05/2024. Now you should be able to edit the condition to check if the date is between these 2 dates.
Posted : 13/05/2024 11:34 pm
