INVALID COLUMN VALUE

CodiK

I am trying to pull a due date based on a prior cell's value.

Example:

Column "Financials Due Date" has a value of 10

In Column "Partners Due Date" I input the following formula but receiving an error. I have the column set to Date.

=DATE(YEAR(TODAY()), MONTH(TODAY()), [Financials Due Date]@row)

Find more posts tagged with

Formulas

Accepted answers

All comments

Todd M Keller

For that to work, you'll want to make sure that your column [Financials Due Date] is formatted as text with just digits for the day populated....... And it will accept invalid input. For example, if Today is in February 2023 and the [Financials Due Date]@row is greater than 28, then you'll end up with a March date in your [Partners Due Date] column.

CodiK

@Todd M Keller Thank you, I did this but now it says "Invalid Data Type"

Todd M Keller

So, your [Partners Due Date] column is formatted as "Date", and [Financials Due Date] column is formatted as text?

CodiK

@Todd M Keller correct, top line shows changing the FDD to text, the ones below are just numbers... PDD are the errors I'm seeing

Todd M Keller

That is a puzzler for sure, I actually tried your setup in a sample sheet. With the column properties set the way I mentioned above, it appears to work.

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.