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.
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 @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.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.