-
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…
-
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…
-
Protect Workspace Sheets From Being Copied
Good Day to Everyone. I have created a project management structure (folders, reports, dashboards, schedule, risk/actions. etc) that I think is fairly thorough and reasonably simple to use. I have invested a fair amount of time in developing this. Is there a way to protect it from being copied by people I share it with?…
-
SUMIFS or SUM(COLLECT) With Cross-sheet Reference
I'm trying to total up hours from a timesheet for each individual across multiple projects. I've tried the following two formulas but both are returning 0. SUMIFS({Timesheet Hours}, {Timesheet Name}, [Resource Name]@row, {Timesheet SOW}, SOW@row) =SUM(COLLECT({Timesheet Hours}, {Timesheet Name}, [Resource Name]@row,…
-
Can Smartsheet forecast end date base on % complete input
For example: Start Date: 10 Jan 2022 (Mon) End Date: 14 Jan 2022 (Fri) For simple calculation, working day duration is 5 days. Each day should achieve 20%. Today is 12 Jan 2022 and I should achieved 60%, but I only manage to complete 40%. Therefore I will need an additional one day to complete the task. So the forecast end…