Why is the Date function not working?
I want to calculate the first day of a month based on the "created date" column. I tried using Year Function to get the year, then the Month to get the month
and last column calculates =Date(([Yearcolumn]@row),([Monthcolumn]@row),1)
Yet I get the #INVALID COLUMN VALUE
year and month formulas are set on number format
What I am missing?
Answers
-
Hi @Manin! Are the Yearcolumn and Monthcolumn set to Date format? Is the column you have the formula in also set to the Date format? They all need to be dates to use the Year (from Yearcolumn), Month (from Monthcolumn), and Date formula.
If Yearcolumn and Monthcolumn are just #s, then you don't need to use the year() or month() in the Date formula. Instead it would be just =Date(yearcolumn@row, monthcolumn@row, 1).
If you are just going off the Created Date then it would be =Date(year([Created Date]@row),month([Created Date]@row),1).
Hope this helps!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 201 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!