-
Projektfortschritt innerhalb der letzten 30 Tage
Auf einem Projektplan wird mir der Erfüllungsgrad des Vorhabens durch die Abhängigkeitseinstellungen (Start/Ende/Erfüllungsgrad) wiedergegeben. Auf einem Projektedashboard möchte ich gerne tagesaktuell, jeweils die zurückliegenden 30Tage betrachten und für diesen Zeitraum (Datum heute/-30 Tage) den %tualen Fortschritt…
-
How would you measure progress by quarter
Hi there, I am hoping to crowdsource some creative answers to a question that has been asked of me by my leadership team. I currently have a Project Management Office/Organization set up in Smartsheet where projects come in with a request form and are managed on an intake sheet, get their own project planning grid &…
-
% Complete Auto-fill / Default value 0%
Hello community :) Is it not possible for % Complete to default/autofill to 0% when inserting a new row? When I insert a new row (between 2 other rows) and enter text in the Primary Column, everything from the previous row gets auto-filled on the newly inserted row as expected (ex: At Risk flag, Project, other columns…
-
Help to create a "3 Dimensional Reference" Formula
I am trying to create a sum of the same cell in four different Metrics Sheets. I have created the following formula and I get the Unparseable error. Would appreciate help, please.
-
Auto fill date and time emailing the wrong information?
Greetings, I set up a very simple form pictured below where someone could select their name from a drop-down and hit submit. On the back end, I have a column called date which enters the date and time of the submission. This information is then emailed to myself and a manager with all of the information in the row. When I…
-
Calculating/Graphing Rolling Averages
Hello Everyone, My master data sheet has a column called "Date Opened" where the date is formatted as Day-Month-Year. I am creating a dashboard and want to create rolling averages. I would like it to count, the number of data points per day, month, and year. I also want to compute averages for these metrics. How would I go…
-
Adding 1 month to date over multiple years - errors
Hello, I have a sheet in which I need a formula to advance a date by 1 month, over multiple years. I have used the below formula, which works to advance within the same year, and move from Dec to Jan, but every month after the new year has somehow changed the day in my date. =IFERROR(DATE(YEAR([Jan '24 RCVD]@row),…
-
Adapting an Existing Formula
Hi, I would like to adjust the formula that comes with the Project Management Office Templates. The Smartsheets template comes with this formula in the "Portfolio Metrics" sheets in the Total column and on the In Progress row. =COUNT(COLLECT({Project ID}, {Project Status}, $Label@row)). I would like to change Project ID to…
-
Free Smartsheet Webinar Series by DigitalRadius
I wanted to share an exciting resource that I think a lot of you will find valuable! Our Customer Success team here at DigitalRadius is hosting a Free Smartsheet Webinar Series now through the end of the year, designed to help you unlock the full potential of the Smartsheet platform. It starts tomorrow! Here’s what’s…
-
Pulling the most recent entry into a report
Hi, I want to create a report that will have the most recent Project Health from a group of Project Update sheets. On each Project Update sheet, I created a help column to show the Max date = 1. I think this will work to get to the most recent update with the most recent Project Health, but I don't know how to construct…