Pivot Table Dates

Marvin Daniels
Marvin Daniels ✭✭✭✭
edited 12/21/21 in Formulas and Functions

I've created a pivot sheet using the Pivot App that includes a date of when a call was taken, however I'm having no success creating an actual date column from the column created by the Pivot App. Please see below for formula reference.

Temp4 proves that Call Date, which is the primary column is not a date, which is expected for a primary column.

In Temp1-Temp3 break that date into year, month, and day values.

However when I attempt to reassemble using DATE() in an actual date column, I receive an #invalid data type.

The Date column is formatted as date.

What am I missing? 🧐


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!