You need to sign in to do that
Don't have an account?
rornelas
use smart dates for future dates
Hi All,
I'm working with this formula below, it works great for past dates but need to have somethign to help me with dates in the future (i.e. for task that were made in the future). Not sure if the today function needs to change or if I need to add something to.
I'm working with this formula below, it works great for past dates but need to have somethign to help me with dates in the future (i.e. for task that were made in the future). Not sure if the today function needs to change or if I need to add something to.
IF(TODAY() - LastActivityDate = 0, "Today", IF(TODAY() - LastActivityDate <= 30, "Last 30 Days", IF(TODAY() - LastActivityDate <= 60, "Last 60 Days", IF(TODAY() - LastActivityDate <= 90, "Last 90 Days", IF(TODAY() - LastActivityDate <= 180, "Last 180 Days", IF(TODAY() - LastActivityDate <= 360, "Last 360 Days", IF(TODAY() - LastActivityDate > 360, "Over a year", "No Activity" )))))))
krishnak2
Have you tried TODAY() - LastActivityDate = -30, "Next 30 days"?