Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here
Jun 18, 2019 09:36 AM
Thanks in advance for your help!
I need to create a formula to determine a project’s classification based on Date Added. There are three classifications: Rocks – 90 days or less, Boulders – 180 days or less, and Mountains – 180 days or more.
Jun 18, 2019 09:45 AM
This should be at least close to what you want:
IF(
DATETIME_DIFF({Date Added}, TODAY(), 'days') >= 180,
"Mountains",
IF(
DATETIME_DIFF({Date Added}, TODAY(), 'days') > 90,
"Boulders",
"Rocks"
)
)