-
Cell Changed Color When Formula Updated
I just updated a date cell formula to give someone a little longer to complete a list of tasks and they all turned yellow. It' not a cell filled color because you can't remove it. I have updated this formula before and not had any issues with the box changing colors, so I can't figure out why it's doing it now. It's a…
-
Smart Sheet Use for Project Management - Meeting Agenda (w/ Form) to Action Item Tracking (Per Proj)
Hello everybody, First time poster. I've searched the forum to find a solution, but I wasn't successful, so decided to create my own post. I'm new to smart sheet, so would appreciate help in getting a solution for my workflow. Just as some additional information - we currently have numerous live projects at any one time,…
-
Project Plan Backward Scheduling / Planning
Implementing backward scheduling in Smartsheet would significantly enhance its utility for project managers who work with fixed deadlines and need to calculate start dates based on a target completion date. Backward scheduling allows users to plan by defining end goals and identifying the necessary steps and timelines to…
-
Formula Question - Integration Project Management Tracker
Hello, I am a project manager in the acquisition space and am creating a project tracker in SmartSheet. One column contains the days +/- from the close date that a task needs to start and another column that contains the days +/- from the close date that a task needs to end. How can I create a formula that will take the…
-
Merged: Grouping in Reports
This discussion has been merged.
-
Can 2 workspaces have same name?
Using the PMO template. I create a workspace for each customer onboarding opportunity that is sold. After a year, I am now getting additional opportunities for existing customers. Is it best to create a new customer workspace, if so, does the name have to be unique? Is there a better way? Here's the PMO folder structure:…
-
Can I attach a form to a Gantt chart to be sent out automatically when milestone is met?
I want to attach a form to a Gannt Chart, so that when a specific milestone is met, the form will automatically be sent to be filled out. I am using the Gantt chart to track multiple jobs, and I want it to send out checklists at certain times during the job process. I created one of the checklists as a form in another…
-
Pasted text from OneNote to Smartsheet cell appears as an image?!
Hi, When you paste text from OneNote into a cell in Smartsheet it appears as an image. This is so annoying. See attachment. The only workaround is to paste the text into a web browser or word document, then copy/paste that back into Smartsheet cell. This is affecting our use case somewhat, as often in project meetings our…
-
Is there a way to utilize one sheet for multiple projects, but still roll up into a dashboard?
I work in an IT department as part of a fairly large school district. We typically don't super fancy PM tools other than a project name, all the tasks associated with that project, who is doing those tasks, and when they need to be completed. So each division in our department has setup their own sheet which as multiple…
-
Recurring Tasks - Please.
Please create some kind of button/feature/right-click that will easily turn tasks into recurring ones (like in Asana or Microsoft Project). The amount of workaround hacks needed to get this to work is tiring, and puts off team members who are not as experienced with bullying Smartsheets into doing what they need it to do.…
