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 2016 Posts
Archives for May 2016
Discussion List
-
Should I have a PM Lite Smartsheet? A One Pager?In Archived 2016 PostsThis time last week, my CIO asked me to look into Smartsheet. One week later I have a beta version of a project template containing 6 sheets, 3 reports, and one dashboard. I was surprised how easy it was to develop a pretty solid solution …
-
Multiple predecessorsIn Archived 2016 PostsHello I have tried to find a solution for one functionality, but nothing is working for me now. I'm trying to make 3 tasks Task A - is a task with fixed start and end dates. Task B - dates taken from A and C like described bel…
-
Grammar/Spell Check RequestIn Archived 2016 PostsCan I request for spell check? This hasn't been an issue (or at least not raised) and I would like to keep it that way. The Chrome browser option isn't so user-friendly; no 1-click scan or doesn't automatically show misspelled words.
-
i am trying to set up an It Service Request Tracker - Need workflow approvalIn Archived 2016 PostsIi am trying to set up an It Service Request Tracker that can incorporate the request being sent to specififc individuals for approval. In other words before a lower level user can submit a request, Mgmt needs to review and approve it. C…
-
Formula to collapse rowsIn Archived 2016 PostsI am looking for a formula to collapse the sub-task rows into the parent after all sub-tasks are completed. I found a formula that will check mark the parent row after all sub-tasks are checked complete, but want to collapse when that occu…
-
Conditional Formatting - Filter odd/even numbersIn Archived 2016 PostsIs there a way to filter and do conditional formatting for odd/even numbers used from auto-number? If not, I would like to pose this as an enhancement request.
-
Conditional Formatting - Track Cost FluctuationIn Archived 2016 PostsI have a master list to track the cost of an item. Is there a way to format cells to change the font to Red or Green based on whether or not the value is higher than a previous cost? IE: In 2015 cost was $1 and in 2016 the cost rose to $2.…
-
Prevent inheriting formatting from previous row.In Archived 2016 PostsI have a sheet where the first row is populated with instructions on how to complete each column (becasue the column title text is so limited - but i digress). That row is formatted in a green color to set it off from the actual data r…
-
Date Formula in a Gantt Chart CellIn Archived 2016 PostsI have tried to add formulas in the start date column for a gantt chart that reference a base start date cell and add a certain number of days to the start date. Is that possible? Example of the formula I am implimenting: = StarteDate…
-
Indenting in Wrong Column (maybe because of Frozen Columns)In Archived 2016 PostsI froze the column "company name" so that it and all the columns before it would follow me across the spreadsheet as I entered data. I am now wanting to indent rows below a couple new headers: "Commitments" and "Pr…