Mod function substitute
I am creating a due date field that will auto update for a Dashboard. The goal is that every 2 weeks an updated date will be shown. From what I can see MOD is not supported in Smartsheets.
I am wondering if someone is able to help me with a mod substitute on a date field like I have done in Excel. The formula in Excel is as follows:
I also attached a JPEG called "MOD Date.jpeg" of my Excel document.
Thanks for any help you can give.
Help Article Resources
Check out the Formula Handbook template!