-
Display baseline variance in timeline view
Display the baseline variance which currently shows in Gantt view as a grey bar underneath actual dates the same way in timeline view.
-
Best way to manage multiple users
Hello, The company I am with has an enterprise license for SS. We have a task where we are storing updates on a spreadsheet, as they evolve, within multiple departments. This has created much discrepancy within the data. I would like to lock it down to about four people being able to enter updates while others submit…
-
Adding a last comment column into a sheet
Is there a way to add a column that updates with the last comment entered into the conversations from that row? For example: If I entered notes from a call that I had with a client "conversation went well, will follow up" that note would populate into a column on that same row labeled last comment or update. This would…
-
Helping Users Understand How Data Flows
We've recently rolled out a PMO solution and are still in the adoption phase. One question I keep getting is how to update Project metadata (such as start/end date). I have to keep pointing people to the Intake sheet. They've been trained on this, but not all training is going to stick. Is this just a matter of repeating…
-
Best Practices for Scalable Sheet Templates in Exec-Level Project Portfolio Reporting
Hi Community, I'm working on building Smartsheet templates that will support executive-level reporting across our project portfolio, and I’d love to hear your best practices and lessons learned. Specifically, I’m trying to design templates that are scalable, easy to maintain, and dashboard-friendly. Here are a few…
-
Assistance with IF, AND, OR statements
=IF([Due Date]@row > TODAY(), IF(AND(Status@row = "In Progress", Status@row = "New", Status@row = "Not Started"), "Yes", "No"))) The goal is to flag items for escalation based on the due date and status. If the due date is in the past and the status of the risk or decision is in progress, not started, or new then I need to…
-
Target Start/End Date
Ultimately, I need a good way to track if we are completing tasks on time based on our original estimates because we have users that estimate a task will take 5 days and when it takes 15 they just change the dates, and the project status still looks green, when is reality it is behind. I would like to have target start/end…
-
Performing an Audit - Best Practice
Hi - we are performing an audit and we need to take the data, and have the consumer validate that its accurate, and if not, identify the change required. What's the best way to tackle that? I was thinking a form but there could be lines and lines of data to validate; is it as simple as having them review the sheet for…
-
Need a formula that returns a date while factoring in dependencies
I’m looking to add a couple of columns into my project plan sheets. SmartSheet already has a [Start] & a [Finish] column built into its project template, but I’m looking to differentiate between [Plan Start] & [Actual Start] and [Plan Finish] & [Actual Finish]. I renamed [Start] & [Finish] to [Plan Start] & [Plan Finish].…
-
Vous voulez diriger un travail plus intelligent, plus rapide et plus percutant ?
Rejoignez-nous le 18 novembre au Smartsheet Summit à Paris. 💡Écoutez les témoignages de Sodexo, PMI, Thermo Fisher, Messika et d'autres organisations mondiales. 💡Découvrez comment l'IA transforme le travail moderne. 💡Échangez avec vos pairs et des leaders de l'industrie. Réservez votre place gratuite