Hi there! I’m trying to do a fairly simple formula but it has quite a lot of conditions. I’m a beginner and not sure where I’m going wrong, could someone help?
The board is a basic project overview. I’m trying to set a column to display “on track” or...
So I found a workaround for this as I noticed that the fields do autofill if you have grouping turned on, but not for the filter criteria.
In your chosen filtered view, just set a new ‘group’ to be the field you want to autopopulate, and drag it to t...
augmented:
IF(
AND(
IS_BEFORE(Due,TODAY()),
OR(
Status = 'In Progress',
Status = 'With Client',
Status = 'Not yet started',
)
),
'Overdue!',
'On track'
)
Ah perfect! Thank you so much for your help, and this has helped me...
Hi augmented, thank you so much!
That is exactly what I’m attempting yes.
Unfortunately this is still giving me an error saying invalid formula - any ideas? I also checked the capitalisation of the Status options in case that was messing with things,...
