Goal: I want to have a cell display a date only if another column has a date. If I use an IF statement, the date is formatted oddly.
Here’s the formula I’m using for my “Next update due” column:
IF({Last update sent},DATEADD({Last update sent}, 30, '...
I found the answer. I need to use BLANK() instead of “”. So the proper formula is
IF({Last update sent},DATEADD({Last update sent}, 30, 'days'),BLANK())
