I have a formula to calculate & set a date specific to the status that the item’s at.
e.g. if Status = A, then date is ‘1 Jan 2023’, if Status = B, then date is ‘13 Feb 2023’ and so on.
am guessing it’s a combo with formatdate - anyone found an answer.
but it shows up as a text and not a date that I can take action on for instance, sending alerts and notifications via automations.
given that we can’t parse values that are not in any columns…your wizardry will help!
Been struggling with setting up the date/timeline thing for 4 weeks now and so far my solutions were
- too cost prohibitive (3rd party app) i.e. low ROI
- mirrored timelines isn’t recognised for automations/formula
- status-specific formulas turned off the automations when activated (team at monday’s on it)
- I can’t do anything with the date in the formula (above)