The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.
Jun 10, 2021 03:13 PM
I know that these types of questions have been asked several times here, but I haven’t been able to replicate suggestions from other threads to get the desired empty cell for my formula. Thanks in advance for any assistance!
My formula is:
DATEADD({Associated Event Date}, {Days before/after event date} * 1, ‘days’)
some of my tasks do not have a value for the {Days before/after event date} field. In these cases, I would like for the cell to show up empty rather than show #ERROR.
Please help :grinning_face_with_big_eyes:
Solved! Go to Solution.
Jun 10, 2021 03:18 PM
IF(
AND({Associated Event Date}, {Days before/after event date}),
DATEADD({Associated Event Date}, {Days before/after event date}, 'days')
)
Jun 10, 2021 03:18 PM
IF(
AND({Associated Event Date}, {Days before/after event date}),
DATEADD({Associated Event Date}, {Days before/after event date}, 'days')
)
Jun 10, 2021 03:52 PM
Thank you, that took care of it!