So I have the following formula
=IF(AND(GO Live Date]@row > [Actual End]@row, [Actual End]@row <> 0), "On-Time", "Exceeded")
And my result is showing # Unparsable.
What is wrong with my formula these are date columns.
Thank you
Hey @Buster Davis
Can you double check that both of your columns are set as Date Type? We can see that the Go Live Date is a Date column, so can you check that the "Actual End" column is set as Date?
I would also suggest checking to see if the Actual End is not blank versus not being 0, since a Date won't ever be 0.
=IF(AND([GO Live Date]@row > [Actual End]@row, [Actual End]@row <> ""), "On-Time", "Exceeded")
Missing a bracket in front of GO.
@Buster Davis
You are missing a bracket on the GO Live Date reference.
=IF(AND([GO Live Date]@row > [Actual End]@row, [Actual End]@row <> 0), "On-Time", "Exceeded")
Hope this helps!
With the correction of the missing bracket, now I am getting invalid operation? Thoughts
Thank you your formula worked perfectly..
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.
