-
Workflow to Update Date to TODAY() until another cell = 100%
I have 2 cells in a column: Which displays a % from 1-100 Which should show a date Is it possible to use a workflow or other automation to daily (at 12:01am or any other time) update the date field to TODAY(), but to stop updating it once the % field = 100%? Thanks in advance!
-
Shout-out functionality
Hello, We are trying to determine if the shout-out functionality is able to be turned off for our group. Does anyone know if this a possibility?
-
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…
-
Editable Report with Shared Sheet that's Hidden/Locked
Is there a way to make the report editable by the user with a sheet that is shared to them as "Editor - cannot share", but making it to where they can't alter the actual properties of the sheet itself? Thanks in advance!
-
Work Insights - column not available to select
I have a column in a sheet that uses a formula (If this field is not blank then status is "Complete"). However, on Work Insights, this column is not available to select. Why?
-
Smartsheet - Logging me out / Closing while working
Smartsheet is logging me out / closing while I'm working on it. I have submitted a support ticket, but have not received any response or feedback. Is anyone else experiencing this issue? It seems similar to the issue that happened on 11/5/21.
-
How to create a top five.
Hi! I've working on a dataset for a while now that essencially logs the everyday orders we receive from our clients. One of the colums records the name of the customer and I've been trying to create a report that counts how many orders a customer has requested and sort them dynamicaly as a top five/ten. It's quite easy to…
-
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…
-
Trying to find a way to update information on existing rows via a form (not via update request)
Hello Smartsheet Community. I have a customer who has uploaded an existing excel spreadsheet into Smartsheet (about 200 rows) which includes information such as email address, first name, last name, etc. as columns. We have created a form to capture new information to each row. Is there a way to set it up so that the new…
-
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.