Hello, Is it possible to apply conditional formatting only in specified rows or does it only apply to the whole sheet? My example is as follows: I am currently tracking production on 20 units. For the first 5 units I do not care if the duration of a planned task exceeds its target. However for the next 15 units, I do want…
Dear Smartsheet, I had a short presentation of Smasrtsheet functionality and I have faced huge problem with notifications. I have a couple of sheets where all notifications are not sent for some reason. I am trying to play with fields that are triggering these notifications and none of them are working. I have checked if I…
Hello, We maintain orders for customers in a sales sheet, the columns look something like this; Order Number Customer name Description Manufacturer Order Status Ship Date Delivery Date Sales Value This is our master sheet. So to update our customers we have to look at the sheet and email them important information from it.…
Hello! I have project sheet, with dependencies enabled. This requires manually updating the % Complete value. I would like to add conditional formatting to remind myself to update the % Complete. IF [Completed]1 is not blank and IF [% Complete]1 does not equal 100% Then Format [% Complete]1 Cell Fill Yellow (screenshot…
We use Smartsheet for our production schedule. The schedule consists of 9 sheets that are all in a workgroup. Is it possible to setup a rule that would allow a row from one sheet to be moved to another sheet using the checkbox feature? Thanks, Jim
Good Day All: I would like a cell to change color (background color) based on a range(See Below). Has anyone used such a formula? My Sheet: https://app.smartsheet.com/b/publish?EQBCT=906e1a0d8f8342e4baead18e6d0a76e4 Overall Rating Score 4.6 - 5.0 (Green) 3.6 - 4.5 (Light Green) 2.6 - 3.5 (Yellow) 2.0 - 2.5 (Light Red) <2…
Hi All I'm building a budget sheet and am trying to figure out how to change the color of the font if it adds up to be over budget. For Example: =IF([Column]1 > [Column]2, "Red") But by doing that, it doesn't change the color, it puts in the word Red. Is there a way to do it in Conditional Formatting that I'm just missing?…
