-
Gantt Insert with Dependency Mapping
I would like to suggest a feature that allows users to insert or embed one Smartsheet Gantt/project plan directly into an existing sheet without creating a separate sheet. Ideally, this functionality would preserve all existing dependencies (predecessors) from the original plan while dynamically updating them to align with…
-
Using a checkbox in formula
Hello All, My existing formula (working correctly) inserts text of REORDER NEEDED or OK option , formula below: =IF([Stock Quantity]32 < [Reorder Level]32, "REORDER NEEDED", "OK") I would like to add a third text insert of "ORDERED" when criteria of a checkbox has been checked in the ON ORDER column -or a date ordered…
-
Past 3 months info graph in a dashboard
Hello, I am looking to project an automated graph that shows the past 6 months in a dashboard. I have a sheet that has a date column with information from the past two years. Also, three different descriptions "Expedited", "Redo", and "Expedited and Redo". I used this formula to get the date from the past 6 months as a…
-
Is there a template for a Decision Matrix?
I am looking for a decision matrix, preferably weighted. Is there such a thing in Smartsheet currently today, or is this something that I have to build?
-
Automated Cells to Drive Gantt Charts
Im am trying to setup a gantt chart for for our production department but am hiving some trouble figuring out how it works. We dont typically use start/end dates but rather work with estimated hours for a project. What ive noticed is that the Gantt chart cant be driven by a calculated cell when dependencies are on. is this…
-
Survey Links
Can someone confirm if rules have changed when sharing a Survey link? In the past, I used to send the link and people did NOT need to open an account , now it seems that they're requested to create one. What would happen if we send the link and they are no longer in the 30D trial? Are they NOT going to be able to open the…
-
Lost access to all sheets – account appears empty despite correct email & region
Hi everyone, I’m experiencing an issue where all of my sheets have suddenly disappeared from my account. Here’s what I’ve already checked and tried: I’m logged in with the correct email address I’ve confirmed I’m in the correct region I’ve checked my Deleted Sheets folder I’ve tried logging in and out in all possible ways…
-
April Question of the Month - Join the conversation and receive a badge
Happy April, Community! We loved last month’s question because it was suggested by YOU, and as expected your responses were phenomenal. We’ve carefully read through all of your insights, and want to thank you for taking the time to share them with us. Pro tip: Feedback is always welcomed. Beyond this month you can continue…
-
Expanding Categories by Default in Timeline widget on Dashboard
It would be nice to choose the default for Timeline widget on Dashboard either expended or collapsed. Currently it's defaulted to collapsed only.
-
Update Assigned Person only for active phases
Hi, I’m using Smartsheet with a Master Sheet(All over Projects Basic Summary) and Individual project sheets that have multiple phases. When I change the Assigned Person in the Master Sheet, I want: •It to update only phases that are Not Started or In Progress •It should not change phases that are Completed Is this…