Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Multiple selections
Is there a way to create a multiple selection option in a column? Was considering Checkboxes that could be linked to the selection by typing next to it or drop down options with ability to select multiple choices? Please let me know if anyone has created something like this or if there is an option to do something like…
Track Date Changes & WBS
Dear SmSh, I have two issue: Issue One : We have submit our plan to client, then during implementation we have delay and date change. how to track the changes ? Issue Two: I found sample WBS sample https://www.smartsheet.com/free-work-breakdown-structure-templates here but couldnt found in the templete. how to draw box as…
Pulling data using web query file
Hi I would like to connect smart sheet to netsuite. Currently i am doung it through web query in excel. Does any body know how to get data into smartsheets using standard web query file? thanks
Getting top x rows
Hi all We're working on a dashboard for senior stakeholders. At the moment we have a report that is an amalgamation of several sheets (listing risks & issues). We now want to limit that amalgamated report to only show top x rows, based on one of the columns (numerical value). So, instead of the current report showing all…
Links not updating
Hi All, I would appreciate it if someone can help me out. I double checked that my links are linking to the correct areas between two sheets. But it is not updating the sheet it links to. Please advise and see screenshot. Thanks, Y
NETDAYS Formula
I cannot for the life of me figure out why the NETDAYS formula is not working for me. Let's say I have my start date as 6/30/17 in cell 6 under column 2 and that my finish date as 7/26/17 is in cell 6 under column 4. I select the appropriate cells for start_date and finish_date and my formula reads…
Auto number parent and child rows
I am trying to auto number the parent rows 1, 2, 3, etc and the child rows 1-1, 1-2, 2-1, 2-2, 2-3, 3-1 etc. Is there a way to do this as rows are added?
When are the LARGE and SMALL formulas coming?
Can we please get an update on these formulas? I was told quite a while ago that large and small formulas were being added, but 2 product updates have come and now I am not getting a response in the original thread about ETA's. https://community.smartsheet.com/discussion/formula-help-top-5-list-aka-large-formula#comments…
2 Gantt Items: child rows and working backwards
Hello! I'm working on a sheet where I want to include sub-tasks via child rows, but the sub tasks do not all start at the same time, nor are they dependent on one another (and happen to be date dependent) but I need dependencies enabled for the sheet. I can't seem to figure out how to have these items start on a date other…
Auto-fill form/cells when a certain item is selected from a drop-down
I was wondering if it is possible to auto-fill cells based on an item that is selected from a drop-down. I am trying to create a form for our subcontractors to upload submittals and I wanted them to be able to select from a drop down list what they are submitting. I.E. Product Data for Paint, or Samples for flooring. Once…
