Using Smartsheet

Post a question about using the core Smartsheet application: sheets, forms, reports, automation, dashboards, and more.

Discussion List

  • Need Guidance - Can you develop a Generic Project Schedule in Smartsheet
    In Using Smartsheet
    Can you create a generic project schedule in Smartsheet?  For example Task 1 starts on Day 1 (start of schedule and month 1) and ends Day 30 (end of month 1), Task 2 starts Day 15 (mid-month 1) and ends Day 90 (end of month 3), Task 3 star…
    31 1
    31 views 1 comment Most recent by Andrée Starå
  • Importing auto numbered columns
    In Using Smartsheet
    I want to be able to import an excel file that will create auto numbered columns (date created and auto-numbered). Is this possible?  What I am trying to do is as follows: I have created a template to make training quizzes for different …
    12 1
    12 views 1 comment Most recent by Shaine Greenwood
  • Smartsheet Merge Add-ons stuck on loading
    In Using Smartsheet
    Hello Team,  I am trying to use Smartsheet Merge Add-ons to print a Row in a Web Form Layout.  I have completed the steps but it does not work, Merge Data is stuck on Loading as shown below:  "Smartsheet Merge will create 1 docume…
    32 2
    32 views 2 comments Most recent by Shaine Greenwood
  • Report Builder - Not Sorting Dates
    In Using Smartsheet
    Hello -  I running reports for partners on the team to provide the user a snapshot of tasks due earliest date to latest date. When I sort A to Z on the finish date it is not working. Any ideas  
    72 3
    72 views 3 comments Most recent by Schiff A.
  • countif red text lines
    In Using Smartsheet
    Hi, want to count "at risk" check boxes to present at a dashboard.   so I thought fx=COUNTIF(Status2:Status14, "red") works, but it only produces 0 as result   Any suggestion   Thanks
    11 1
    11 views 1 comment Most recent by Kara Lumley
  • % Complete formula
    In Using Smartsheet
    Hi, I need to be able to calculate the % complete of a project in the parent row based on % complete of a number of tasks in the child rows and the project duration without using Predecessors column.   Can anyone help??   Thanks, Bill
    Bjg Profile Photo Bjg
    31 1
    31 views 1 comment Most recent by Kara Lumley
  • countif red text lines
    In Using Smartsheet
    Hi, want to count "at risk" check boxes to present at a dashboard.   so I thought fx=COUNTIF(Status2:Status14, "red") works, but it only produces 0 as result   Any suggestion   Thanks
    11 3
    11 views 3 comments Most recent by Mike Wilday
  • Gantt - Task Name, Start and End Date
    In Using Smartsheet
    Hi...I would like my gantt chart to show the task name, start date and end date. Is this possible?
    31 3
    31 views 3 comments Most recent by Andrée Starå
  • Show multiple labels on the Timeline Display
    In Using Smartsheet
    Any column can be selected as the label on a bar in the Gantt Chart timeline display. It would be nice to have the option of selecting multiple columns to display. For instance employee and description, task name and cost, assigned to and …
    406 5
    406 views 5 comments Most recent by Andrée Starå
  • why does my conditional formats fail to function when the set conditions exist?
    In Using Smartsheet
    why does my conditional formats fail to function when the set conditions exist?
    104 Profile Photo 104
    11 1
    11 views 1 comment Most recent by Alison