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
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!