This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I have a formula setup to show a status based on an 'Expiry Date'.This works from a date column {Expiry Date} with a column that works out the difference in days called {Diff}, this uses the formula: DATETIME_DIFF({Expiry Date}, NOW(), "days") Then i...
Thank you, Dan! This worked perfectly and I've learnt something new In case anyone wants my exact formula to duplicate it is:'Diff' column - DATETIME_DIFF({Expiry Date}, NOW(), "days")'Status' column -IF(Diff <= 0,
"❌ Expired",
IF(
...
