Pulling a value from a field utilizing an IF statement

I am trying to complete a formula, and am getting an invalid column value, however. Can you help?

Trying to have the formula look at a Revised Due Date column and if it is blank to pull the Due Date column value. If it is not blank, pull the revised due date column value.

=IF(ISBLANK([Revised Due Date]@row), [Due Date]@row, [Revised Due Date]@row)

Find more posts tagged with

Accepted answers

Jeff M.

I tested you formula before looking into a possible solution and it worked on my end. Invalid column value could mean that the column containing your formula is not set to "date" type column.

Try adjusting the column properties and see if that works for you.

Have a great night!

All comments

Jeff M.

I tested you formula before looking into a possible solution and it worked on my end. Invalid column value could mean that the column containing your formula is not set to "date" type column.

Try adjusting the column properties and see if that works for you.

Have a great night!

Sam29

I changed the property of my column to a date restriction and it worked! Thanks you!

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.