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.

Archived 2017 Posts

Archives for December 2017

Discussion List

  • Filter what other can see&edit
    In Archived 2017 Posts
    My Company from Slovenia is using SmartSheet to track inquires/sales all over the world. Each inquiry gets its own line and we enter in this line also country from where demand came from. Curenty we use this sheet only internal-  only in c…
    68 3
    Closed 68 views 3 comments Most recent by Schiff A. Archived 2017 Posts
  • Forms
    In Archived 2017 Posts
    Is there a way to make templates for Forms and then add them to each of our projects?  I see where you can build forms and then clone them inside of a sheet but we would be looking to copy those forms into other sheets.  Is there an easy w…
    49 1
    Closed 49 views 1 comment Most recent by Mike Wilday Archived 2017 Posts
  • Project Plan views / Task assignee see's just their tasks
    In Archived 2017 Posts
    I have read posts where it says to use project plan FILTERS or create one off REPORTS to execute this requirement. This seems inefficient and each option lacks what the other provides.  NEED: I want an all in one feature within a project…
    54 1
    Closed 54 views 1 comment Most recent by Schiff A. Archived 2017 Posts
  • "Publish User" when using Microsoft Teams.
    In Archived 2017 Posts
    When a user makes changes to a cell in a smartsheet from inside a tab in Microsoft teams (either in the Teams app or in the Teams Web Client), when looking at the Cell History the cell changes are logged as belonging to "Publish User&…
    168 1
    Closed 168 views 1 comment Most recent by Shaine Greenwood Archived 2017 Posts
  • for two criteria query should I use LOOKUP or INDEX MATCH
    In Archived 2017 Posts
    I need to populate the low range based on a  match to a specific specialty and tier.  The specialty is just a drop down but the Tier was based on the following IF formula: =IF([Points Total]11 <= 15, 3, IF([Points Total]11 >= 16, 2,…
    417 1
    Closed 417 views 1 comment Most recent by Robert S. Archived 2017 Posts
  • ISBOOLEAN help please
    In Archived 2017 Posts
    Hi Team, I have a formula that calculates tax automatically as I enter the amount. I wanted to add Checkbox column, when I tick the box it removes tax and if its untick it continues with original formula.      =IF(Status1 = "WON&quo…
    134 4
    Closed 134 views 4 comments Most recent by Heath Sanders Archived 2017 Posts
  • Time Tracking - Formula needed to total time spent
    In Archived 2017 Posts
    Has anyone used SS to track actual time spent? I am using the "Time Track for Client Projects" template modified for simple tracking of time spent for individual tasks by client or department. I cant seem to get the formula neede…
    367 3
    Closed 367 views 3 comments Most recent by Robert S. Archived 2017 Posts
  • Publish with Filter ON
    In Archived 2017 Posts
    I have a card view that is set to display with a filter on by default.  Is it possible to also Publish this to the Web with a filter on by default?
    451 3
    Closed 451 views 3 comments Most recent by Rizzi-CTX Archived 2017 Posts
  • Report with only parent rows
    In Archived 2017 Posts
    I am new to Smartsheet and I'm trying to create a report from multiple sheets that have parent rows and child tasks.  I'm looking for a report that puts together all the sheets but only shows the parent rows from each sheet along with the …
    757 4
    Closed 757 views 4 comments Most recent by Jose Alvarez Archived 2017 Posts
  • Do not show parent row in calendar view
    In Archived 2017 Posts
    Hi, Is there a way to set up hierarchy with several tasks and different dates, and not have the parent row's date, which ranges from the first to the last date in the tasks below it, show in calendar view? I want just the children rows to…
    227 2
    Closed 227 views 2 comments Most recent by Joachim Mund Archived 2017 Posts