This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
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: ”)
