IF Statement with multiple dates an count.

Hello,

I have a large sheet that I am trying to calculate several dates to populate dependent on a Count in a row field (ie - a count of 0 would generate a date being pulled from one column, and a count of one generating a date from another column).

Columns in Question:

"Was Rejected" - this is a count on either it has text on a rejection reason column (generating a 1) or no text in the reason column (generating a 0)

"Date Requested" - I would want this to populate if it was a 0

"Date Rejected" - I would want this to populate if it was a 1

My current formula is "=IF([Was Rejected?]@row=0, [Date Requested]@row, [Date Rejected]@row) It is returning "#INVALID COLUMN VALUE". Any thoughts on what I am doing wrong?

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

Make sure all three columns are set as date type columns.

All comments

Paul Newcome

Make sure all three columns are set as date type columns.

Jivi3

Thank you!! That worked! I have never tried anything like this so still learning. I really appreciate your help.

Paul Newcome

Happy to 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.