Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 09, 2023 01:44 PM
Hi All-
I am looking to have a conditional field in grid view so that if we are approaching an expiration date, the field will change color according to how soon- e.g. using (TODAY) red if 30 days from expiry, yellow 60 days, green 90 days. So far, I am not having luck with the IF formula in the condition field.
1 Reply 1
Comment Post Options
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎May 09, 2023 02:07 PM
IF({Expiration Date},IF(DATETIME_DIFF({Expiration Date},TODAY(),'days')>=90,'🟩',IF(DATETIME_DIFF({Expiration Date},TODAY(),'days')>=60,'🟨','🟥')))
Reply