-
Giving an output based on text from multiple selection dropdown
Good Afternoon, I've been racking my brain trying to get this function to work. I have a column set up to allow multiple selections of specific text with the column name "Processes." I want the cell to find the specific text and give a number value. I'll then pull from a "Due Date" column giving the processes start date…
-
Gantt View has come to WorkApps!
Hi Community, We have to admit, not having Gantt view in WorkApps kind of limited the scope of its project management functionality. Fortunately, we’ve gone ahead and taken care of that. Our latest release enables WorkApps to support Gantt view in the sheets experience! App users can now build pages using this view and end…
-
Shouldn't predecessors and dependencies work differently?
This is not just with Smartsheet, but any project planning software I've seen so far. Dependencies have four types, and this is how they work: Finish-to-Start (FS): The "normal" type of dependency. This sets the start date equal to the day after the finish date of the predecessor. You can adjust the duration or finish…
-
How to put both estimated & planned dates on a sheet?
Hello, I work in a company that supervises multiple construction projects accross Europe. We have a report with all the projects that our construction partners consult in order to plan their resources for the right time. The issue is that the dates are not necessarly exact and we need to find a way to distinguish the…
-
Is there a way to set up automated reminders for just specific columns in a sheet?
I'm working on a sheet that has lots of columns, so want to create an automation to remind people to only update specific columns on a biweekly basis. Is this possible?
-
I am trying to create a formula with varying conditions
I am trying to create a formula for the likelihood of a project. I have 2 helper columns and a final column. I am only worried about 1 of the helper columns as I cannot get it to work. The Conditions I am missing is for when a project is planned to start in the middle of a year, I want the % to carry over until 0, and…
-
Numbering Duplicates Based on a Date
Please see above a sheet for quote submissions, I want the revision number to automatically number the duplicates of service and contractor based on submission date with the oldest being revision number 1. Currently the Revision Number formula is: =IF(ISBLANK([Service + Contractor]@row), "", MATCH([Row ID]@row,…
-
Anyone use Smartsheet for tracking legislation?
I work for a state government agency, and this year we are developing a workspace to help the department track bills of interest/impact as they make their way through our state legislature when the next legislative session opens in January. Does anyone have any examples of what they use for something like this?
-
Creating a metrics sheet based off a project intake form
Hello, I'm looking to set up a separate tracking sheet that captures ongoing counts based on our project intake form. I'm hoping to capture: # of requests created by Department (uses a dropdown on the main intake sheet) # of requests per Program (uses a dropdown on the main intake sheet) # of requests by Type (uses a…
-
Form Drop Down Populated by Separate Sheets?
Is it possible to connect a drop down column in a sheet to another sheet as a lookup for relevant values? This would enable centralized control of values ensuring they are accurate for form submission. Looking at articles on Data Uploader, this would be too powerful for the specific use case below. Obj: Users are only able…
