-
Conditional Formatting with percentages
Hello all! I am wondering if there is a way to use the conditional formatting with percentages. For example, I have a report with inconsistent data in each column (some percentages, some just numbers). When I try to condition as greater than 90%, greater than .90, or greater than 90 it includes the full numbers as well…
-
Conditional Formatting on Two Comparable Values
Hi All, I'm very new to Smartsheets and struggling to figure the conditional formatting/formulas out. I have two number columns 'EBT' and 'ABT'. I need to conditionally format them so if ABT is more than EBT, it flags red. If ABT is less than EBT it flags green. Thanks! :)
-
Formatting Rows under Parents
Hi all, Is there a way of creating a formatting rule where if a category from a drop down menu is chosen, that row will move under a parent row? e.g. we are doing a protective workwear smartsheet, we would like to categorise things by type of PPE - 'hand and arm protection', 'face protection', 'skin protection' etc.; once…
-
Sort column indicator
Is it possible to have the sort column automatically highlighted? I.e. when sorted by column A column a gets highlighted... when sorting is changed to column B, highlighting automagically changes to column B. Possibly this could be a user specific color or other type of conditional formatting. Or even just getting a visual…
-
Conditional Formatting copy from one sheet to another
Did SmartSheet add the feature to copy Conditional Formatting from one sheet to another?
-
Check Box with multiple criteria
Hello - I am trying to get a checked box: If Column A value = Column B value, check box. However, I am also getting checked boxes when A and B are both blank which should not happen. Current formula is: =IF(AND([TRACcess Serial Number as Per TRACcess Manager]@row = [TRACcess Serial Number As Reported by Tech]@row), 1, 0)…
-
How to conditionally format based on sum of children?
I currently have a meeting agenda sheet. In the parent row for the meeting I'm calculating how many meetings have been reserved for the meeting versus how many have been put on as agenda items. In the parent row I have a formula: ="60 minutes have been reserved for the meeting and " + SUM(CHILDREN()) + " minutes have been…
-
At Risk Formula that utilizes end date and status columns only...
I am stumped. I have tried various formulas only for them to error. The closest I have come is the following but I am missing pieces. =IF([End Date]@row = "", 0, IF(AND([% Complete]@row < 1, [End Date]@row < TODAY()), 1)) BUT... I need it to do more: I need it to NOT USE % Complete I need it to flag at least 14 days prior…
-
Compare two dates in the two cells.
Hi, I want to compare two dates, if the dates are different in the two cells I want them to glow red. What formula do I have to use and where to put it ?
-
Updating/Refreshing my file from a different website?
I have a file that I need to use updated fuel pricing at all times. The website my excel file is linked to updates once a week, usually on Tuesday. Need: How can I have this sheet refreshed from the website (EIA.gov) onto my Smartsheet file? Nice to have: I would like the data point I use on the sheet to be rounded to 2…
