Unparseable error

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())

Find more posts tagged with

Formulas

Accepted answers

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.

All comments

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.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.