-
Conditional Formatting Not Working
Hello, I've set my CF rule to look like the screen shot I have attached. I've been over it for what seems like 100x but it's just not working. Can someone please help?
-
Format key and Primary Column
Hi all! I have two questions: 1. I have several conditional formatting rules that change colors or font based on contents. Can anyone recommend the best place to put the "format key" to indicate what each color and font means? I currently have it in an attachment, but that's not so easy to reference. 2. Does the Primary…
-
Formating for dates past
I'm looking to set a rule for when my 'Finish' date column pass my 'Completion' date column. When I try to set the rule it only allows me set when passes a fixed date rather that a date set in a certain column? any help welcome. thanks G
-
Conditional Formatting Help
See Screenshot Example Please Goal: to compare cells in 2 rows across columns. All numbers in both these rows are based off formulas. I want the cell in row "needed machine hrs" (column 1) to turn RED, IF the number is greater than the number in the cell directly below it, in row "Current Machine/Labor Hrs" (column 1). Is…
-
Linking
I was wondering if smartsheet linking has the capability to perform this following type of function: If I create a Request Log spreadsheet, and one of those columns has a drop down with options, approved, hold, pending, is it possible to create a function wherein once that approved selections has been made then that row of…
-
Conditional Formatting
I want cells that need to be filled in with values to be highlighted. Like, if A2 and B2 contain a value, highlight C2. Only problem is that C2 has a formula so it's not technically "blank". And I want the formatting to go away once the formula has been overwritten. The formula is there because if someone indicates "Y" in…
-
Another parent-child condition format scenario
I've search Community and found several very excellent formulas that fall into the parent-child conditional format category; however, they rely on a checkbox type to function. In my scenario, the child row has a conditional format that when a date is within 15 days of target date, the row is highlighted. I'd like the…
-
Conditional Formatting or Formula
Good Day All: I am trying to use Greater Than Conditional Formatting for two columns. However, Conditional Formatting does not allow you to select 2 columns. Perhaps, I have to use a formula? Here is what I would like to do: If % Complete (Planned) is Greater than % Complete (Actual), then Red If % Complete (Planned) is…
-
If and Formula tracking date, progress with ryg status dashboard
To share back with the community here, I'd like to share some key formulas that I've been helped with by the community and extensive testing/fixing. I have a sheet that tracks: * progress for items based on user inputs of %age complete * compared to the progress they should have completed so far (%age expected as of the…
-
Sort columns by color
Hi, Is there anyway to sort columns by fill color or text color? When we need to draw attention to certain items in Smartsheet In Excel we use color coding to sort. That ensures that the specific criteria requested will be presented on the top...(not all the criteria are the same ex. by date, so conditional formatting…
