-
formular syntax code editor
Hi all, I have some complex and long formulas in my sheet wit a lot of brackets. Do you know any syntax editor which I can use to document and analyse the formulas? Should have highlighting for opening and closing brackets etc. Thanks
-
How to implement default highlight color in to field name
Hello, At present Smartsheet providing highlight changes for recent updates. Is it possible to add a column/field to indicate the recent changes col name in that field.? For example I want to see all the recent changes for the past 2 days in the new column/field it will show this particular row Col-B and Col-D was updated…
-
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…
