-
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…
-
Expand (wrap text) and Color Code in Card View
You can see below by the +2 and +1 that more information exists. I know you can float over it to see what is there, but I would prefer to have the card expand to show them all. Is that possible? Also, I'd like different options to display in different colors - how might I do that?
-
Conditional Formatting Not Transferring to Card View
I set up conditional formatting which works in my grid view, but when I switch to card view, it is not showing the correct formatting. Here are some screen shots. Thoughts/Suggestions?
