Hello, I'm wondering how I can sync a dropdown menu (Status Column) to another column (Percentage Complete). Ideally, this function would change the Percentage Complete column to 100% when the status …
New to SS. Setting up many project sheets and then want the high level info pulled together onto a master sheet. Videos I've watched say to create a master sheet and link data in from project sheets. …
When we first had access to Smartsheet, we were able to view all of our update requests on one screen. Did that go away or am I just missing it. Is there any other way to consolidate that information?
It would be great to be able to use relative addressing in cell linking between sheets and links in reports and sights instead of the fixed linking as currently implemented in Smartsheet. Why? We use …
In short... if I pull a date from another sheet using "Link from Cell in Another Sheet", I can't do formulas off that date. I've verfied that the columns are formatted as dates. [Opening Date]1 is lin…
Hi Everyone, I am relatively new to smartsheets and there are two things I have been trying to work out adn for the life of me can not find the information to show how its done. The first is having a …
Hey SS Community, I am involved with a company that currently has no central data base overviewing all projects. I want to put a system in place where the PMs can manage their own projects. Also a sys…
Hi guys, I'm eager to understand the easiest approach for using the Link Cell functionality with templates. I am building a 'Project Master Listing' document that will have cell links to multiple 'Ind…
Hi, All my project sheets are all set up with project, status, start date, end date, duration, %complete and predecessors. I also have a checkbox column to mark when a task is complete. I'd like to fo…
Typical project management templates are not designed to easily get a distilled summary of important points. I am wondering if these is a template out there that would allow for easily pushing out or …