completed task names auto skipping other tasks?

Keith Hans
edited 12/09/19 in API & Developers


I am trying to create a project where depending on a certain task completing or not, the project sheet auto skips other listed tasks.  This is very simple, but very hard to communicate via words what I am trying to do. 

For example, lets say I have a project that lists out how to drive a car.  Task 1 is does it have gas, if you answer no in the task, it will take you to the how to fill up the car with gas area of the project, if you answer yes, it will skip the filling it up with gas area of the project list.

Does this make sense to anyone?  I feel like I have seen this before and it should be a simple procedure/setup, but i am having trouble finding details about it.  Its most likely because I am not communicating it properly in writing.

Thanks for any help you can add!


  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    How do you have this laid out and how do you want the results displayed? Are you using checkboxes, dates, or some other way to mark as complete?


    I am understanding what you have posted, but to be able to find a working solution for you, we will need more details. Screenshots help tremendously as well.

  • Keith Hans

    Smartsheet support updated me, seems this isnt an option :(


    "Thank you for reaching out to Smartsheet Support. I understand you want to setup a sheet, where when a change is made to a row, the sheet will take you to another linked row. We do not currently have this feature, but I can recommend a similar setup as workaround.


    Smartsheet offers a powerful organizational feature, the indent tool, which allows for creating row hierarchies. Rather than facing hundreds of rows in one project, easily condense your data so you can focus on a particular aspect and how it relates to the project as a whole.


    You can create a hierarchy on your sheet by indenting rows. When you indent a row, it becomes a child of the row above it (the parent row).


    NOTE: Hierarchy is created from the child row. It is not created by designating a row as a parent.


    Note that hierarchy creates relationships between rows, it doesn't control row formatting.


    You can setup your sheet so that subsequent tasks will be under the primary task, and indented to become the child task. This will allow the child tasks to collapse into the parent task, and only be visible if necessary.


    For more information on Rows and Hierarchy:"

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi Keith,

    I might have some ideas for a workaround as well. I'm with Paul. If you can share some screenshots that would help immensely.

    Have a fantastic week!


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


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

    W: | | P: +46 (0) - 72 - 510 99 35

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

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭



    If you are able to post some screenshots, we may be able to create a workaround using some basic formulas to generate prompts.