Formula stopped working
My formula updates the next date still works but stop working to update the %due column.
My formula and screenshot
=IF(AND(ISDATE([Last Date]@row), ISNUMBER(Frequency@row)), DATE(YEAR([Last Date]@row) + (FLOOR((MONTH([Last Date]@row) + Frequency@row - 1) / 12, 1)), IF(MOD(MONTH([Last Date]@row) + Frequency@row, 12) = 0, 12, MOD(MONTH([Last Date]@row) + Frequency@row, 12)), DAY([Last Date]@row)), "")
Answers
-
The formula you shared updates the next date based on Last Date and Frequency. Can you share the one that is not working and explain how it is not working? Is it returning the wrong number? If so, how what does it return and what do you expect? Or, is it returning an error message?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!