I’m working on a board to track the deadlines to sweep a certain item 30 days after it’s promise date. I also needed to include an if statement to set the date 30 days from today, if no promise date is available. To do this, I’m utilizing Autoboost to provide a formula within my automation, as such:
The formula I’m using is:
IF({item’s Current Promise Date}=“”,ADD_DAYS(Today(),30),ADD_DAYS({item’s Current Promise Date},30))
This formula works if there is a promise date, but yields an error if there isn’t. Both statements within the if statement work on their own but nested together seem to be causing an error. Anyone catch any errors in my formula logic?