I have 3 columns with different dates. My goal is to enter 1 date, and have the other 2 dates formulated based off the 1st date. I created a formula to satisfy this need, but I am ending up with some …
Hello! I'm looking for recommendations on the best (aka easiest) way to create and manage subprojects within a project. Our current systems are set up to have 1 project number, 2XXXXX, with several su…
All I wanted to show you how I am using smartsheet to keep my budget reporting in real-time. I have 3 sheets 1) A Budget sheet 2) An Invoice Sheet 3) A Project Action Log The purposes are as follows B…
I downloaded the project management office template set and wondering a few things. Do I copy the "Project Template" folder and rename it for every different project? I'm assuming the "Portfolio Level…
Hi, Is there a formula I can use to find the average "word" used in a column? For example, I want to find the average of these words from the drop-down list: Cheers! Ann
I've been playing around with this all day. I'm trying to figure a way to compile a list all the unique values in a given column (in this case, business entities/customers). I'm matching that against …
Hello All! I wanted to see if someone could assist me with fixing a bug I created. I was using the Project Management Office (PMO) template set and the 'Project Intake Form' and 'Project Intake Sheet'…
Hi everyone, I have the following asset booking system and received feedback that I should add a time component to it: Unfortunately, I haven't been able to get it to work correctly as, in the above s…
Hi Everyone, I have set up the following automation: Unfortunately, the automation does not appear to be working: I've saved the sheet and refreshed the page multiple times. Can someone help me troubl…
Hi All, I have just uploaded the Agile product roadmap template from smartsheet to create my roadmap in smartsheet account. After creation, I have not been able to visualise the end product as a roadm…