Gordon’s Profile

Community member since July 2015



I am working on producing a report which pulls from a Task sheet (database) based on certain specific tasks and specific statuses.  Each task has an "Assigned to" cell which contains a restricted list of contacts (our employees).  

I have been asked to sort the resulting report by the "Assigned to"



I have a column where I indicate the budgeted hours available for a task.  Within the Duration cells, I would like to enter a formula that takes the budgeted hours, divides them by an efficiency factor and yields the resulting duration available for the task, however, I'm unable to enter any




I am trying to see if any of the Excel wizards here can help me with a script or other macro that will disaggregate my SS exported project sheet data that contains start and end date columns (along with the usual duration column) information into individual rows for each day/date that is


We’ve just rolled out a new release that includes improvements to Smartsheet Sights, Reports, and User Management.

Note that the referenced Help Center articles below will be updated with information on the new features tomorrow, Sunday (11/13)

Let’s take a look at these new features!


  • A new