-
Workbook template set for new project
Hi there, My first post to this forum and somewhat new user to Smartsheet. Can anyone advise if below is possible and if yes, how to do this or point me to help on this topic. Thanks a million! *** I want to create a template set for a suite of document that I need to create for every project. What I do today is use an…
-
How do you make a Program roll-up
How do you make a roll-up of multiple indivdual projects. Wtihin each of the project dependencies is turned on.
-
Rookie Help with Due Date and Overdue
I have a start date column, due date column, completed date and would like to have overdue flag column. How to set formula that if due date passes, no completed date and have flag come up in overdue column?
-
Change Status Bubble Color Based on Percentage
Have tried using conditional formatting to achieve this with no luck. I have a column of % complete with percentages in increments of 5. I then have a seperate column of status that I am using a gray, red, yellow and green ball image. I'd like to for the color of the ball to change based on the percentage chosen (i.e. gray…
-
Advanced Notifications options - add scheduled notifications.
I like the improved Notifications functionality and would like to add one more suggestion. Can you add a "Delivery" capability so that the frequency/Date/Time for the notification can be customized? This is similar to the existing functionality in SmartSheet Update Requests.
-
Conditional Formating : Done/Status based on items below it.
I am using a sheet to tract information being sent by candidates. Is it possible to make the Red Dot in the "Done" Category next to "Candidate Name" Turn Green automatically when all lines associated with it are turned to green/done. I've been trying to get conditional formatting to work but I can't figure out what the…
-
Keeping parent Task during filter search
I have been using the Parent Task as a header for child task below. The child task has an owner, the header does not. I'm in construction so for example the Contract header has child items such as site visit, develop scope etc. My owners don't want to see all the items that they don't own and I have a filter for each owner…
-
How to make Gantt bar color dependent on condition: if a task is a child (subtask) of a selected par
I have created a sheet based off of the Team Task List by Priority template. I have changed the priority task names to reflect the names of our team members. This allows me to group the tasks by tech, so the sheet's description would more accurately be Team Task List by Tech. I had conditional formatting set up to…
-
Outline level field
I'm an (expert) Excel user, using Smartsheet now in our organisation for basic tracking functionalities. It's a daily 'struggle' to understand the limitations of Smartsheet and try to keep the sheet basic and simple, but I'm quite enthousiastic about Smartsheet. On the other hand, I really miss some (in my point of view)…
-
Creating a formula that relies on conditional formatting
Hello all. This may be out there, but I am not really sure what search words to use, so haven't had much luck in seeing if anyone else has come up with a solution. I am trying to create a formula that will calculate the sum of all cells in a column that meet a specific format, in this case, shading. I do not want to have…