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

  • KPH
    KPH ✭✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!