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)

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.