-
Conditional formatting
Hi All, i wonder if there is a formula to help me out to change the task color bar match with my Assigned to column
-
Automated workflow trigger not working
I have set up a series of simple workflows to change a cell's value based on data in another cell. If the source cell value is changed to "50%" for example, the destination cell will automatically be updated with the number 5. There are several different source cells being used, some of which are "yes/no", and some with a…
-
Calendar View from Grid with Linked Cell (as Dates) not Populating Calendar
I have a calculations grid that summarizes a large data set (populated by formulas against a main grid). To do this, I had to create helper cells that are rather ugly and should not be seen by my audience. As a result, I created a new Grid (Reporting Grid) that is linked to the calculations grid. It's a grid made up of…
-
CHANGE ON SITE AFTER IS CONFIRMED
I have a column “Equipment Order Status” that has a dropdown (Ordered, On Site, Shipped, Delivered) and another column “Equipment Confirmed Arrived” that has a dropdown (Not Confirmed, Confirmed). I would like when I choose from Equipment Confirmed Arrived” column the option “Confirmed” the column “Equipment Order Status”…
-
Complex nested IF, AND with traffic light symbols
Hi All, I'm working on automating a symbol highlighter to indicate project progress as well as alerting if key milestones are being compromised. The formula below is structured based on the following columns: * Finish: The Activity completion date * Start: The activity start date * Date: A column containing fixed dates to…
-
Automation Troubles
I have an employee that stopped receiving automation alerts on a particular sheet. She receives them on other sheets and the others involved are still receiving them even though she is not. We have deleted the automation and re-added, we have deleted just her and re-added, we have created a whole new automation just for…
-
Suggested or maximum payload size for Update Rows?
I've got a service that updates a sheet's rows with data from another source. It works fine on a sheet that has <5000 rows and around 19 columns, but I keep getting error 4002 whenever I'm trying the service with a sheet with >11000 rows. Is there a maximum number of row objects (and cell data) that is suggested to ensure…
-
Unable to create cross-sheet references
The system shows a message "Unable to create cross-sheet references because this sheet already contains the maximum number of different cross sheet references" . How many references we can do? I am using a sheet that has information of 13 sheets combine. (like a summary sheet). I like the summary sheet but the information…
-
Pulling data into a "master sheet"
Hello all, I am trying to pull select data from multiple sheets into one "master sheet", however I am struggling to find a working method. I am unable to use reports due to them not connecting with datashuttle. I have tried VLOOKUP, Copy Row automation, INDEX/MATCH and a few more but i can't get them to pull all of the…
-
Hyperlink Color on Dark Background
Hi, I'm new to SmartSheet so I may have missed something. When I add an hyperlink on a cell with dark background, is there a way to make the text white or any other color that would allow to read it? I thought the automatic mode would change the color, but it does not let me do so... any ideas? Do I have to stick with…
