-
how to get the circle quarter symbols to change colour???
Ok so I am using the below symbols with a formula in background to be in different qtrs/ stages of a project.... Background Formula is: =IFERROR(IF([%]@row <= 0.01, "Empty", IF([%]@row < 0.26, "Quarter", IF([%]@row < 0.51, "Half", IF([%]@row < 0.76, "Three Quarter", "Full")))), "") However, I want to change the colour as I…
-
Cell change color based on content
I have 365 columns. When someone updates a cell to "PTO" I want the cell color to change to Orange. I have only found conditional formatting that will work for this, but I'd have to create 365 rules. Any other way to accomplish
-
Linking cells in a Gantt chart
Hello, Has anyone figured out a work around to link cells from one Gantt chart to another when you have dependencies? The main point of linking a cell from one file to another is so that it updates when information changes. I need to have dependencies in the Gantt, but also really want to make linkages from one Gantt to…
-
Dynamic Report Filters
I don't think this is a feature, but it would be extremely helpful if it was. Let me share the details. We often use the method of creating a template of something, lets say a sheet, two reports, and a dashboard. We keep these four in a folder, and if we need a new one, we'll copy the folder to the correct location, rename…
-
Gantt Timeline Colors
Hi, We have a gantt view that is showing two different colors in the view and we would like to have the timelines display in one consistent color. Can this be changed? Thanks
-
Forms Updates? ie signatures
Anyone know of any changes coming to forms? I use forms for all kinds of things within my company but I think there are some key features missing. I would be able to use Smartsheet exclusively if the forms could capture signatures. There are many "documents" that require this and it seems like it would be an easy fix.…
-
Help creating reports from source data that share the Primary Column
Hello! I hope someone can help me with the query below. I have two Sheets that share the Primary Column but any other column is different . I want to create a report that displays the content from both sheets under the same line if they have a Primary column in common. In the example below, the row would display A under…
-
Name in Cell History
Hello! I have an automation set up to change a flag to "Flagged" when a certain date and criteria are met. The automation to update the flag is working beautifully; however the name in the cell history for who triggered the flag seems completely random. This is creating an issue because those flags are triggering automated…
-
Copy Configuration from Smartsheet Commercial to Gov?
If we build an solution in a Smartsheet commercial environment, is it possible to easily copy/lift that configuration into a Smartsheet Gov environment? I know that you cannot share between environments, but not sure on copying configurations. I appreciate any insights you can provide. Steve
-
how to count how many times a particular value is appeared from dropdown over a range
Hello, For eg: In the picture, we see that column4 has four values in the dropdown (orange, apple, pear, banana). I want to count how many times "orange " has appeared in the column4. Thanks
