Feb 08, 2019 09:41 AM
Hi! Below is the formula I’m using
DATEADD({Fast Action $7K Paid},30,‘days’)
I want to prevent the “#ERROR!” message from appearing when the “Fast Action $7K Paid” box is left empty. This field won’t always be used and the error message constantly showing is a tad frustrating. What do I need to add to the above formula to ensure that when nothing is put in the “Fast Action $7K Paid” then the error message won’t show in the next box?
Thank you for any and all help!
Feb 08, 2019 09:58 AM
IF({Fast Action $7K Paid}=BLANK(),“Error Will Robinson”, DATEADD({Fast Action $7K Paid},30,‘days’))
Feb 08, 2019 10:25 AM
So that looks right and THANK YOU! But I’m now getting the message that that formula doesn’t work
Feb 08, 2019 10:27 AM
you have to re-type the single quotes(maybe the double as well), they get formatted as a different but similar character in the forum. (copy and paste from the forum doesn’t work as we’d like)
Feb 08, 2019 10:28 AM
That did it! Thank you Michael!
Feb 08, 2019 10:31 AM
One more question Michael as this adjustment has now caused another error. How do I adjust DATEADD to only be the date and not the time. I don’t have the option to edit it using formatting with this formula for some reason.
Feb 08, 2019 10:34 AM
have a look at this
The DATETIME_FORMAT function will allow you to reformat the data from the date-type field into a string of your specifications. This is written in the form "DATETIME_FORMAT(Datetime, 'format s...
Feb 08, 2019 10:49 AM
Thanks, I’ll have to take a deeper look at it as the adjustments I made from that support article didn’t work.
Feb 08, 2019 10:51 AM
put your formula into: DATETIME_FORMAT( your formula, ‘M-D-YYYY’)
Feb 08, 2019 12:59 PM
That unfortunately didn’t work for me either.