-
Auto calculate the estimated date of completion
Hello, I want to auto calculate the estimated date of completion based on the current status and pending work items in the backlog.
-
Change Cell Value not working
My sheet has a Start Time Column and End Time Column. Both are single select 'Restrict to dropdown values only' I also have an "All Day" checkbox column This sheet is populated with the use of a form On the form, I have logic to only show the Start and End times when All Day is not checked. I'm trying to populate the Start…
-
Formula to show Current Status of Project Approval
Not sure if this would be accomplished easier with a Formula or with a Update Cell Workflow. We have a Projects Smartsheet that have 4 different Reviewers that need to approve. I'm looking to add another column for Reporting purposes that will show what approval step each project is on. For example, based off my attached…
-
How record a date automation work?
Hi, I'm having trouble using the record a date automation. as you can see in 1st picture, I create record a date when "send noti to slack" is checked in 2nd picture, every change I made in that check box is from 25-Nov-2021 but record date show 24-Nov-2021 does anyone know why? and what I have to do to make it record the…
-
Copy Row Automation
I have two separate sheets. On sheet 1 I would like to type in a date and then it would copy that row over to sheet 2. When doing this the data is populating down at the bottom of the sheet when the data ends in row 26 the copied row is getting pasted in row 131 or something like that. Not sure why or what do to do fix…
-
Customized button text not reflecting on approval workflow
Hi, When we customize the button text under 'Approval Workflow' it still shows default values i.e. 'Approve' and 'Decline'. Is there any workaround available.
-
Is that possible that Smartsheet automatically writes hierarchy numbers for tasks level ?
-
Automation - Approval workflow - Button text
Hi! Couple of days ago, my approval workflow does not show the customised button texts, but the default "Approve" and "Decline". Is there a way to fix it?
-
Workaround for Sheet Reference Limit?
Hi everyone, On our project we have two sheets, a project plan which contains around 50 items, each containing around 9 sublevel actions. We have a separate sheet that we were manually maintaining in excel containing all of these sublevel actions organized in rows based on the 50 items. Our goal is to have this sheet…
-
Dynamic Drop Down lists from another column either within the sheet or from another sheet
I've searched, but everyone seems to say that this is not an option at the moment, are there any work arounds? I want to create a page where someone can create a product id number based on several factors, i.e. category, model number, color, country, end customer I'f like osmeone to be able to select the category (call it…