The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Hello there,
Thanks to this community I’m well on my way to creating a “days since last contacted” graph, but I’m running into an issue.
I have a rollup column that uses the MAX() function, and then a formula column that runs this calculation:
DATET...
Managed to come up with a solution, so just thought I’d share:
Created a secondary Date Column [Raw Date]
Blockquote IF({Date} < TODAY(), DATETIME_FORMAT({Date}, ‘MM-DD-YYYY’), BLANK())
This ensures that if the date has not happened yet, the value ...