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 Mont…
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
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 "Hou…
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 …
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 …
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 proj…
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 inv…
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}, …
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 6…
I was hoping to get some help with a question regarding the WBS template from SmartSheet I found this template very helpful, and I would like to use it for my projects, but I need a little assistance …