Hey! we have around 200 rows in a board, each with a timeline. I need to know the ones that are starting, ending or in progress ‘tomorrow’ only. Using the ‘future’ filter doesn’t work as it gives me everything with future dates. I’m trying to use the General Castor app, using a formula and casting the result to a status column. The status will be ‘Tomorrow’ otherwise blank if its not happening then. I can’t seem to get the formula right. Can anyone help, or is there a better way of doing this?
2 Likes
Hi@char_sumfen ,
The following formula can be used in the General Castor app to filter rows that are starting, ending, or in progress tomorrow.
IF(
DATE(timeline.start_date) = TODAY() + 1,
"Tomorrow",
"")
Hope its helpful to u.
For further implementation details kindly connect us:
MSquare Support
Visit us here
Youtube Channel
1 Like