Charting and Tracking duration of row item

Hi all,

We track all of our roles our team is hiring agains in Smartsheets. As I'm creating a dashboard, I'm looking to see if there's an easy way to track and display (see image) how long each role sits within a bucket.

For the sample image:

The x axis would contain our recruiting "buckets" (i.e Review, HR, TA, Filled etc.). The y axis would be the time/duration per step with the displayed data being every role we have.

I'm not sure if this functionality is possible, but thought I'd check to see.



  • Genevieve P.
    Genevieve P. Employee Admin

    Hi @Sarah_Ko

    Smartsheet Charts map data based on what's stored in the underlying sheet or report. Do you have the time/duration per step stored as a number in a text/number column? If so, we could potentially create a stacked bar chart to show something similar.

    Could you post a screen capture of the source data (but block out any sensitive information)?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!