Need Help Debugging Formula

[Jit02 (Hello World)]

Hi everyone,

Since I am not very familiar with formulas in Monday.com, I would really appreciate your help.

I am currently working with a formula column on my board, but I keep getting an “unexpected error” when I try to use my formula. I believe the issue is in the formula itself, but I am not sure what’s wrong.

Here is the formula I using:

What I am trying to do is: “Take the FY End Date, add 157 days (5 months + 1 week) to it, and show the result in another column.”

Has anyone encounter into a similar issue, or could kindly take a look and help me spot what’s going wrong?

Any help or suggestions would be greatly appreciated!
Thanks in advance!!!

[hellotimi (David Kalu (Formula PRO - Use formula column results in automations!))]

You can use this formula instead:

FORMAT_DATE(ADD_DAYS({Date 5}, 157), "YYYY-MM-DD")

However, to copy the result of the formula to another column, you will have to use a 3rd party app like Formula PRO Automations, it allows you copy the result of the formula column to other columns like mirror columns, item names, subitems and many more. It also has support for a lot more functions than the native formula column like IFERROR, SKIP, IFNA and many more.

You can use the recipe, if column changes, retrieve the calculated value of formula column and project result to column.

Let me know if that helps.

You can add formula pro to your board for free here