Unparseable error

Joe Haney

I am getting the 'UNPARSEABLE' error on the following formula, any insight would be appreciated:

=IF(MIN([FPFV (Updated)]1:[FPFV (Updated)]107)= [FPFV(Updated)]@row, (MAX([Actual Go Live Date]1:[Actual Go Live Date]107)+7), TODAY())

Joe Haney

Thanks - I ended up using a helper cell to house the max go live date then use that to add the 7 days to.

M Underbrink

Without seeing your sheet, I think your problem is that you are trying to add 7 to the date that gets returned using that MAX() formula. You might have to them DATE() formula in the method mentioned in Row 3 of this article answer: https://help.smartsheet.com/articles/2477601-use-formulas-perform-calculations-dates

Row 3 explains how to add days using the date() function.

Let me know if that works!

Joe Haney

Thanks - I ended up using a helper cell to house the max go live date then use that to add the 7 days to.