-
Keep Health Status Formula When New Row Created
I am really close getting my health status formula that is based on both Status and Date to work. I need the formula to stay when a new row is added. I also want the status to be GREEN with DUE DATE = TODAY. Here is what I am trying to have happen If the DUE DATE is in the past turn the health symbol "Red" If the DUE DATE…
-
Calculating Time in HH:MM:SS
Hello, I'm hoping someone might be able to help me with calculating time in Smartsheet. We work with production teams in broadcasting, as well as other non-production teams, so calculating time is becoming rather vital, as more and more departments are using Smartsheet for a varying number of use cases: people and resource…
-
Counting Cells that contain text
Good Afternoon, I'm trying to add columns that only contain text. I have a column where the users insert "issues" that they have with that particular line item. At the bottom of the sheet, I need to have a running total of how many issues are listed (and then make a graph) so I am trying to make a formula counting blank…
-
COUNTIF by MONTH in Sheet Summary Field
Hello, I'm trying to count the number of entries created in a month, based on the timestamp from the system generated Created field. I am able to do this with a helper column, where I perform the Month() function from the Created field in a column and then use the Countif formula in the Sheet Summary field (ex: To…
-
Is there a way to set sheet card view as default for all users of a sheet?
I have a sheet that is best in card view. Is there a way to set this as a default view for all users of the sheet or does everyone have to set it themselves? Thank you
-
Resource Management
Hi, I have the Smartsheet Resource Management integrated with our Smartsheet Project schedule and all setup was done by Smartsheet folks for the enterprise. Note that the time tracking setting is "Hours and Minutes." My goal now is to track the resource allocations by project and phase (see example below). For instance,…
-
RAG indicator at parent level Vs Child
Hi All, I need help on a formula. In my current schedule the RAG is determined by % complete of task, desired% as on today and low tolerance. Here the parent level is indicating RED although child is in green and blue but no RED. Probably due the Desired % is more than the actual % but the actual % for child task is more…
-
Gannt chart help please
Hi, i'm using the excel template which smartsheet provide here: https://www.smartsheet.com/top-excel-project-plan-templates in the file ive downloaded the gannt chart looks lovely, however when i add in my project plan which has loads more tasks than the example, and over a greater time period the gannt chart severs no…
-
Tracking hours spent on a task
We need to track the actual time spent on each task (daily and/or weekly) in addition to the percentage completed (gantt) . Any ideas how I can configure that?
-
For a Project Portfolio Roll Up, SUM of Total Budget IF Project is Active/In Progress
I'm using the Project Management Office template set; however, it does not come with Budget totals, health, etc., like it does for the Schedule. I had no problem adding budget info for individual projects and displaying them on the project dashboard. I am now trying to get this information to roll up to the Portfolio level…
