Is there a way to change the date that Work Insights goes off of?

Right now work insights creates the date ranges based off the creation date of the row itself.

This is not conducive for what I am trying to accomplish.

I have a separate column for "Hired Date" that I want to be able to sort the data from Work Insights.

Is there anyway to change what dates Work Insights uses in your sheet?


  • Would someone please help. Anything. This product has been insanely frustrating to use. Nothing is intuitive. You should be able to just specify easily what date field the work insights goes off of but you cannot. Infuriating.

  • Khasim
    Khasim ✭✭✭✭✭

    Hello, BlueJay.

    Work insight will generate charts by default. However, you can select a specific field or create a new chart and select Hire Date filed.

    I hope this has answered your questions.

    Thanks & Regards


    SSPM Consultants

    Email ID: [email protected]

    Did I answer to your question or fix the problem? Please help the Smartsheet Community by voting it Insightful/Vote Up/Awesome, or/and Accepted Answer. It will make it easy for others to discover a solution or help in answering!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!