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

  • 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

    Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!