Using Smartsheet

Welcome to the New Smartsheet Online Community


You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.

Using Smartsheet

Discussion List

  • andrew.taylor37161
    Answered andrew.taylor37161 24 views 6 comments Most recent by Richard Rymill SBP
    First post 01/20/20,Last post 01/23/20
    Hi I am creating master sheets with the basic information that most of our sheets would require. We are a Strata company so that info would be the names and addresses (and other data) of all the buildings we have under management. I then w…
    Using Smartsheet246
    andrew.taylor37161
  • ahill
    Answered ahill 16 views 6 comments Most recent by Andrée Starå
    First post 01/21/20,Last post 01/23/20
    Is it possible to use query strings to link a filtered sheet? E.G. ?Row=1&Task=Review&Resource=John If so I think this should be submitted for enhancement, as it could prove to be extremely useful.
    Using Smartsheet166
    ahill
  • Tucker Webb
    Answered Tucker Webb 13 views 3 comments Most recent by Richard Rymill SBP
    First post 01/22/20,Last post 01/23/20
    Hi Smartsheet, I have the following problem. I am a contractor that has to go around a home and take a materials count on a list of tasks say a door install, window install, etc. Anyways, I am trying to figure out the quickest and best sol…
    Using Smartsheet133
    Tucker Webb
  • Ken Young
    Answered Ken Young 59 views 5 comments Most recent by Andrée Starå
    First post 10/14/19,Last post 01/23/20
    Hi All, Our department is looking to produce a Training Request form for our staff. How do we set up an automated workflow where it'll allow the original requester to edit the training request if it has been declined by the manager?  For…
    Using Smartsheet595
    Ken Young
  • SummerEdwards
    Answered SummerEdwards 26 views 9 comments Most recent by Andrée Starå
    First post 01/10/19,Last post 01/23/20
    Is there a way to limit form entries to one per person?  Can the link to the form be limited to single use? Thanks in advance!  
    Using Smartsheet269
    SummerEdwards
  • lisa.nichols43261
    lisa.nichols43261 241 views 21 comments Most recent by Julian Sindall
    First post 04/03/18,Last post 01/23/20
    i have a sheet that has data with dates added from a form. it always adds a new request from the form to the top and i have to manually sort it by date in descending. is there not a way to have it automatically add the data by the date in …
    Using Smartsheet24121
    lisa.nichols43261
  • nskoulphong
    nskoulphong 20 views 1 comment Most recent by Andrée Starå
    First post 01/17/20,Last post 01/23/20
    Hello, I am considering requiring interviewees perform a skill test in Smartsheet as part of the recruitment process. Has another done this? If so, do you mind sharing what you have? Thank you.
    Using Smartsheet201
    nskoulphong
  • Sarah Krueger
    First post 01/22/20,Last post 01/22/20
    Are there Portfolio or Program templates that will display tasks in a gantt chart or horizontal timeline view?
    Using Smartsheet192
    Sarah Krueger
  • poweb048
    Answered poweb048 16 views 3 comments Most recent by Andrée Starå
    First post 01/15/20,Last post 01/22/20
    I have rather long project sheets and several standard reports (Over Due Tasks, Tasks Due Next Week, etc) and include "Sheet Name" as a column in all. Each person is active on multiple sheets (projects), so all their assigned &a…
    Using Smartsheet163
    poweb048
  • Tom.Richards
    First post 01/17/20,Last post 01/22/20
    New user looking for some advice. We need to: Capture requests from a form(s) and save the original data. We know comments and attachments will be made by other users, and we don't want them to mess up what was originally there, or the or…
    Using Smartsheet375
    Tom.Richards
  • Nolan Schmidt
    Answered Nolan Schmidt 25 views 1 comment Most recent by Paul Newcome
    First post 01/20/20,Last post 01/22/20
    I work with large data sets on parts (60,000 SKUs) and I have a form and workflow for processing special pricing requests from our field. I'm curious if I can house the prices on an external excel file or sharepoint and pull in the pricing…
    Using Smartsheet251
    Nolan Schmidt
  • michael_hostetler85551
    Answered michael_hostetler85551 9 views 1 comment Most recent by Paul Newcome
    First post 01/22/20,Last post 01/22/20
    Workspace owner has created a form and published it. Users that are members of the workspace receive an error when attempting to submit the form. Error message is: There was an error submitting the form. Please try again. If the proble…
    Using Smartsheet91
    michael_hostetler85551
  • Kimberly Greene
    Kimberly Greene 16 views 4 comments Most recent by Paul Newcome
    First post 06/19/19,Last post 01/22/20
    Now that you can do cross sheet formulas am I able to create s sheet for metrics data that can tally columns from another sheet using formulas? 
    Using Smartsheet164
    Kimberly Greene
  • Clark Everson
    Answered Clark Everson 16 views 1 comment Most recent by Paul Newcome
    First post 01/22/20,Last post 01/22/20
    Is there a way to track if a project is running on time? Is a new cell column needed or how would you do this using End Dates etc? We want to display this in a dashboard (using klipfolio)
    Using Smartsheet161
    Clark Everson
  • Corina Terrazas
    Answered Corina Terrazas 10 views 1 comment Most recent by Paul Newcome
    First post 01/22/20,Last post 01/22/20
    Is there any functionality in place right now or planning for the future to allow a workspace/sheet creator to share ownership privileges with another individual? As a Project Manager, this ability would be extremely useful since many time…
    Using Smartsheet101
    Corina Terrazas
  • Juley Mathew
    Answered Juley Mathew 21 views 1 comment Most recent by Genevieve P.
    First post 01/20/20,Last post 01/22/20
    Hello, How can i set up a column to calculate how long it took to complete a task from the date it was assigned to date it got completed? I don't understand the dependencies in the project settings.
    Using Smartsheet211
    Juley Mathew
  • mgriffin
    First post 06/05/18,Last post 01/22/20
    I've read through all the instructions on https://help.smartsheet.com/articles/2476691-compare-live-data-with-a-chart#faq, and I'm still unable to create a chart like the one shown in the example. It says that the chart widget only support…
    Using Smartsheet1976
    mgriffin
  • Tomer
    Tomer 96 views 12 comments Most recent by Lisa Luetkemeyer
    First post 08/16/18,Last post 01/22/20
    Hi,  I’m part of an in-house legal department. The company has different departments and different types of contracts/advice they require us to produce. To track the work, I have created one sheet for the legal team to use, covering all…
    Using Smartsheet9612
    Tomer
  • TSP
    Answered TSP 24 views 1 comment Most recent by Genevieve P.
    First post 01/21/20,Last post 01/22/20
    I have an activity sheet set up by weeks. Meaning the same rows/sections are duplicated multiple times throughout the sheet. As the user fills in the names of their "Appointments" , what formula can I use to count that through…
    Using Smartsheet241
    TSP
  • Cheryl Petrich
    Change Time into MilitaryAccepted Answer
    Accepted Answer Cheryl Petrich 45 views 19 comments Most recent by Paul Newcome
    First post 01/15/20,Last post 01/22/20
    Hi all - Looking for solution to a simple task. Using a form that shows date in this format: 8:00 AM, 9:30 AM, etc., Want to add a second column (that will be hidden from form) that changes this to military time. No calculations involv…
    Using Smartsheet4519
    Cheryl Petrich
  • SYSPK
    SYSPK 28 views 9 comments Most recent by Andrée Starå
    First post 11/08/18,Last post 01/22/20
    There is a little disclaimer on Smartsheet's article about automated alerts under using double bracket placeholders. Has anyone experienced this happening to them? NOTE: Adding placeholders to your messages may possibly result in you rece…
    Using Smartsheet289
    SYSPK
  • M. David
    Question vs. DiscussionAccepted Answer
    Accepted Answer M. David 22 views 3 comments Most recent by Genevieve P.
    First post 01/21/20,Last post 01/22/20
    Hello. With the change of the Community Forums, I am seeing less activity on several of my submissions. Can someone explain the difference between, "Ask a Question" and "Discussion?" I have been submitting issues as &qu…
    Using Smartsheet223
    M. David
  • ALAIN-STEPHANE
    Accepted Answer ALAIN-STEPHANE 25 views 11 comments Most recent by Paul Newcome
    First post 01/21/20,Last post 01/22/20
    Hello , Does " Automatic numbering for Work Breakdown Structure " exist in SMARTSHEET ? It's been a couple of days now that I am searching for . Can someone help me ?
    Using Smartsheet2511
    ALAIN-STEPHANE
  • siouxzie7
    Answered siouxzie7 35 views 2 comments Most recent by siouxzie7
    First post 01/15/20,Last post 01/22/20
    I'm using Smartsheet for recording software QA test results. There are some tests that when/if they pass, as indicated by a checkbox, that pass should cascade to pass other tests. The other tests may be in one or more other test groups: Te…
    Using Smartsheet352
    siouxzie7
  • Angie Hatfield
    Answered Angie Hatfield 14 views 2 comments Most recent by Angie Hatfield
    First post 01/21/20,Last post 01/22/20
    I have a checkbox column that is used when a project and any of it's tasks are Active. I have another checkbox column that is used when a project and/or any of it's tasks are Done. I have another column that will generate the date when th…
    Using Smartsheet142
    Angie Hatfield
  • sdonnelly
    First post 01/22/20,Last post 01/22/20
    I have an automation workflow in one sheet that I want to use in a different sheet. Is there a way to copy this workflow and then add it to my other sheet (similar to how you can copy summary reports from sheet to sheet)? Or do I need t…
    Using Smartsheet131
    sdonnelly
  • Mareike
    FormAnswered
    Answered Mareike 16 views 3 comments Most recent by Andrée Starå
    First post 01/21/20,Last post 01/22/20
    I created a form some months ago and I need to expand it now by some columns, but the update just doesn't show for the user who is filling in the form. Can anybody help? Thanks!
    Using Smartsheet163
    Mareike
  • Rishabh Ghuwalewala
    Answered Rishabh Ghuwalewala 20 views 3 comments Most recent by Genevieve P.
    First post 01/17/20,Last post 01/22/20
    Hello Smartsheet Community, I am planning on sending out a form periodically (every 2 weeks) requesting certain users to feed in the tasks they have performed for that period. I was hoping to set each response as a child row, while the per…
    Using Smartsheet203
    Rishabh Ghuwalewala
  • SYSPK
    Answered SYSPK 6 views 1 comment Most recent by Andrée Starå
    First post 01/22/20,Last post 01/22/20
    How can I track when the numbers in a cell increase? We have cells that fluctuate all the time. They contain SUMIF formulas that pull from another sheet. I'd like to know when a cell increases- not just if it changes at all. Is this possi…
    Using Smartsheet61
    SYSPK
  • Angie Hatfield
    Angie Hatfield 34 views 10 comments Most recent by Andrée Starå
    First post 02/04/19,Last post 01/22/20
    We are having issues with pages loading and submitting forms. The following message is returned. I emailed support. Anyone else having issues?   This page isn’t working app.smartsheet.com didn’t send any data. ERR_EMPTY_RESPONSE
    Using Smartsheet3410
    Angie Hatfield