Hello Everyone,
I am looking to set a status based on a two separate dates.
Example:
Set Status to Late if…
If there is no date in Due Date A column and the date in Due Date B column is two weeks from today’s date or later OR if the date in Due Date A column is two weeks or more later than the date in Due Date B column.
The only answer I see is having a separate “Today’s Date” column. And then a number counting everyday after that date which would stop counting based on the status.
Any thoughts or maybe some good app suggestions appreciated.