=IF(Created@cell 30,[Days Since Creation]@cell 45, [Days Since Creation]@cell 60, [Days Since Creation]@cell 120, [Days Since Creation]@cell 180, [Days Since Creation]@cell<210)), "Yellow","Red")))

Why is my formula #UNPARSEABLE?

=IF(Created@cell < DATE(2021,6,30),"Gray",IF(OR(AND([Priority]@cell = "P1",[Days Since Creation]@cell <= 30),AND([Priority]@cell = "P2",[Days Since Creation]@cell <=45), AND([Priority]@cell="P3",[Days Since Creation]@cell<=60), AND([Priority]@cell="P4",[Days Since Creation]@cell<=120),AND([Priority]@cell="P5",[Days Since Creation]@cell<=180)),"Green",IF(OR(AND([Priority]@cell="P1",[Days Since Creation]@cell>30,[Days Since Creation]@cell<=45),AND([Priority]@cell="P2",[Days Since Creation]@cell>45, [Days Since Creation]@cell<=60), AND([Priority]@cell="P3",[Days Since Creation]@cell>60, [Days Since Creation]@cell<=90), AND([Priority]@cell="P4",[Days Since Creation]@cell>120, [Days Since Creation]@cell<=150), AND([Priority]@cell="P5",[Days Since Creation]@cell>180, [Days Since Creation]@cell<210)), "Yellow","Red")))

Find more posts tagged with

Accepted answers

Sameer Karkhanis

See if below helps (Column names should still be cross checked as mentioned before)

=IF(Created@cell < DATE(2020,6,30), "Gray",
	IF(OR(AND([Priority]@cell = "P1", [Days Since Creation]@cell <= 30),
				AND([Priority]@cell = "P2", [Days Since Creation]@cell <= 45),
				AND([Priority]@cell = "P3", [Days Since Creation]@cell <= 60),
				AND([Priority]@cell = "P4", [Days Since Creation]@cell <= 120),
				AND([Priority]@cell = "P5", [Days Since Creation]@cell <= 180)
			),"Green",
		IF(OR(AND([Priority]@cell ="P1", [Days Since Creation]@cell > 30, [Days Since Creation]@cell <= 45),
				AND([Priority]@cell = "P2", [Days Since Creation]@cell > 45, [Days Since Creation]@cell <= 60),
				AND([Priority]@cell = "P3", [Days Since Creation]@cell > 60, [Days Since Creation]@cell <= 90),
				AND([Priority]@cell = "P4", [Days Since Creation]@cell > 120, [Days Since Creation]@cell <= 150),
				AND([Priority]@cell = "P5", [Days Since Creation]@cell > 180, [Days Since Creation]@cell < 210)
				), "Yellow","Red"
			)
		)
	)

All comments

Sameer Karkhanis

I don't think you can compare the date directly as 06/30/20. Please replace that with DATE(2020,6,30) instead. (Also month of June has 30 days only :-) ) [Also assuming all the rest of the syntax with brackets and commas is good]

MistyDingus

Thanks Sameer. It looks like I might have some other issues with syntax. I made some adjustments based on your comment and have edited my original post to reflect, but ultimately it's still unparseable.

Sameer Karkhanis

Check if the columns names used in the formula match with those in the Sheet (case matters so look for that too)

Sameer Karkhanis

See if below helps (Column names should still be cross checked as mentioned before)

=IF(Created@cell < DATE(2020,6,30), "Gray",
	IF(OR(AND([Priority]@cell = "P1", [Days Since Creation]@cell <= 30),
				AND([Priority]@cell = "P2", [Days Since Creation]@cell <= 45),
				AND([Priority]@cell = "P3", [Days Since Creation]@cell <= 60),
				AND([Priority]@cell = "P4", [Days Since Creation]@cell <= 120),
				AND([Priority]@cell = "P5", [Days Since Creation]@cell <= 180)
			),"Green",
		IF(OR(AND([Priority]@cell ="P1", [Days Since Creation]@cell > 30, [Days Since Creation]@cell <= 45),
				AND([Priority]@cell = "P2", [Days Since Creation]@cell > 45, [Days Since Creation]@cell <= 60),
				AND([Priority]@cell = "P3", [Days Since Creation]@cell > 60, [Days Since Creation]@cell <= 90),
				AND([Priority]@cell = "P4", [Days Since Creation]@cell > 120, [Days Since Creation]@cell <= 150),
				AND([Priority]@cell = "P5", [Days Since Creation]@cell > 180, [Days Since Creation]@cell < 210)
				), "Yellow","Red"
			)
		)
	)

MistyDingus

Thanks for your help on this Sameer.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.