-
Help with Index Formula
Hello! I am creating one master sheet for a variety of portfolio metrics (we currently don't have control center - working on that!) and am having trouble figuring out the best formula to populate the data I need for this one item. I want to calculate how many strategic projects vs. KTLO projects a team has for the…
-
How can I link predecessors from one sheet to another?
A task in sheet A is required to be completed before a task in sheet B can be worked. Is there a good way to do this? Note: I also have a master sheet that is fed from the values in sheet A and B combined. I want to be sure the integrity of that link carries over into our master sheet. Thanks!
-
Bow Tie Templates?
Does anyone know where I can find a template for bow ties in Smartsheet? It's not a new tool, so I'm sure there hast to be an example already built somewhere. Thank you!
-
How do you implement Deadlines?
This is sort of a feature request, but I'm posting here to see what other people do in Smartsheet or maybe even other planning software to show a deadline. It's a funny thing, as I've seen this better implemented in hodge-podge put together spreadsheets than I've seen it in actual planning software. In such spreadsheets,…
-
SmartSheets as Project Tracker-Too many manual steps. There has to be a better way
Buckle up. This one's a longread. TLDR: Skip to steps 5, 8 and 9 on this list. I've been using SmartSheets over the past month or so to replace my project management / status trackers. I like the automations (mostly) and that it seems fairly easy to use. It seems like it has some problems that I find very surprising and…
-
Dynamic View won't let us choose a drop down item in the details panel
I have a dropdown list of a few statuses that I added to our details panel. It worked yesterday but now isn't. An error populated once that says 'you have invalid changes. Please review and try again' but now that doesn't populate- it just won't save.
-
Merged: RYG (G)(B) Status/Health
This discussion has been merged.
-
Recreating Report in a Sheet
Hello! Our team has a financial tracker and our timesheets in Smartsheet, and I am trying to find a way to link them. The goal is to take the number of hours worked on each project, and multiply them by our average rate to get a rough estimate of our current labor cost. Our reporting also needs to separate time between our…
-
Total number of days a resource has been allocated
I’m working on a project with multi resources. Is it possible to run a report that shows the total number of days a resource has been allocated? So, I can calculate the work effort against a resources? Thank you
-
'Current User' default in web form
Hi, Is there a way to set a web form field to default 'Current User'? Like we can pre-filter a report for example. Cheers, Rick
