Each week the PM sets the RAG status of a project for the weekly report.
Is there a way to automatically capture that RAG status and keep a history so you can see a trend?
If your plan captures RAG as one row corresponding to the Project Name, which probably will be the highest level in the hierarchy. You can add one more checkbox (possibly as "Project") and have it checked for this row. You can then create a Copy Row workflow to copy with your trigger being date driven and you can specify it to run weekly on a certain day and copy over that row of data to a new History sheet that you can create per project.
For your reporting, you can create reports pointing to the history sheet you create.
Copernicus Consulting Pte. Ltd.
P: +65 9230 5657 | E: [email protected]
Feel free to reach out for licenses, services, and training on Smartsheet
Thanks for that reply Aravind. I will give that a go.
I forgot to mention that the RAG is stored on the Sheet Summary along with all the report details. But I can pull that to a cell on a row using a formula.
Hi all. I am new to Smartsheet and I am building my first form. Is there a way to set up a form to show additional fields that will only appear after it is submitted? These new fields will be filled out by someone other than the person who submitted the form. They will be viewing this in the card view. Thanks for any help!
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.