Help

Error in Date calculation Formula

Topic Labels: Formulas
1079 2
cancel
Showing results for 
Search instead for 
Did you mean: 
delta1286
5 - Automation Enthusiast
5 - Automation Enthusiast

I am having trouble getting this formula to work. I need it to calculate 28 days from column one and insert the date in column two, and if no date exists in column one the second column should be blank, any help would be greatly appreciated guys, thanks.

Error-AT-DT

2 Replies 2

Hi @delta1286 - I don’t think there is a problem with your formula - the same works for me. Looks like the issue is in the name of the field, although from your screenshot this has been corrected (note lower case in the error message compared to the field name). Not sure how to fix this - maybe recreate the Letter of Claim column and the review date formula?

JB

Hi Jonathan, thanks for that, I changed the name of the filed and it worked! thanks for your help.