joshmead - profile

joshmead · Apr 05, 2024

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...

joshmead · Apr 05, 2024

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( ...

User Statistics

User Activity

Status based on expiry date

Re: Status based on expiry date