Smartsheet Basics

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Timeline for multiple items

✭✭
edited 05/28/24 in Smartsheet Basics

Hi!

I'm looking to track a process for individual items (same process but different starting dates). The item goes through a process and has wait times after each step. I'm trying to use each line item as the item itself and then add the dates for each step with wait time.

For example:

Item 1

Step 1: 11/29/23-12/30/23

Step 2:12/30/23- 1/10/24

Step 3: 1/10/24-2:12/24

I know that I could list each step individually, but I have 240 items with 6 steps each. Is there an easy way to do this in Shartsheets?

Thank you!

Answers

  • Community Champion

    Timeline for multiple items

    Hi,

    I hope you're well and safe!

    Can you share some screenshots? (Please delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

    I hope that helps!

    Be safe, and have a fantastic week!

    Best,

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

  • ✭✭✭✭✭

    Do you want to use Smartsheet 'Timeline' view or is that just how you are describing it?

  • Screenshot 2024-05-28 063326.png

    What I want to do is map the time for each of these steps and the lead time in between. I started doing it in excel (see below) where each item is one line and the steps are on the same line, so A-F would have a different color. I'm just not sure if this is something that Smartsheets can do.

    Screenshot 2024-05-28 063938.png

Trending in Smartsheet Basics