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

  • Victoria_Indimar
    Victoria_Indimar ✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!