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.


Thanks!


Answers

  • 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)?

    Thanks,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!