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,
I’m trying to write a formula that assigns the status ‘current’ to the records of the current week plus 12 weeks prior to that. The intent is to always have a way to single out the latest 13 weeks, meaning, every week the oldest week should ha...
I’ve been sitting here for half a day trying to get this right also. I have over 300 fields to link for a rollup, so there’s just no way I’ll manually link these…
Any other way I can go about using the SUM value in another table?
I have worked out how to do this with DATEADD… thanks anyway if anyone looked into this. :slightly_smiling_face:
IF({Date Created} >= DATEADD({Record Created},-12,‘weeks’), “Current”, “Past Weeks :hourglass_flowing_sand: ”)