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: ”)
