Getting Unparseable error using IF function

Hello,

I am trying to use the IF formula to perform a date calculation based on a value selected in another column but keep getting UNPARSEABLE error.

Here is the formula that I have used. I have also pasted the screenshot for reference. Can anyone help me out on this?

=IF([SLA]@row = "Standard",[Feasibility_Start Date]@row + 15, [Feasibility_Start Date]@row + 25)

I am trying to calculate the Feasibility_End Date from the Feasibility_Start Date based on the value selected in SLA.

Both the Feasibility_Start Date and Feasiblity_End Date columns are set as Date.

Find more posts tagged with

Accepted answers

KPH

Hi @nsvikram

The formula looks good. Can you try clicking into the cell the formula is in and seeing if the cell references are cooler coded? It should look like this:

Screenshot 2025-09-08 at 10.42.48 PM.png

If they are not coloured, it could mean the underscore used in the column name is not the same as the one in the formula.

If that looks good, try dragging the formula down to the row below and then back up again. That will sort of refresh the cell and make sure a previous error is not causing it to continue to display the error message.

All comments

KPH

Hi @nsvikram

The formula looks good. Can you try clicking into the cell the formula is in and seeing if the cell references are cooler coded? It should look like this:

If they are not coloured, it could mean the underscore used in the column name is not the same as the one in the formula.

nsvikram

That worked! There was a typo in the header name in the column. Fixing that made the formula colour coded, and I got the result. Now I'll make sure to look for the colour to confirm if the formula is correct.

Thank you very much.

nsvikram

Thank you very much.

KPH

Excellent news. Glad I could help.

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.