INVALID COLUMN VALUE
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)
Answers
-
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.
-
@Todd M Keller Thank you, I did this but now it says "Invalid Data Type"
-
So, your [Partners Due Date] column is formatted as "Date", and [Financials Due Date] column is formatted as text?
-
@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
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!