I'm looking to create a formula to change an individual's cell color if the checkbox for the cell is checked. I've tried different formulas but can't seem to get it right.
All columns in the specific sheet include checkboxes. If the checkbox is checked, I want the cell background to be green. If the box is unchecked, I want the cell background to be gray. Can anyone help me understand which formula to use?
Thank you!
0
·
I believe you're looking to create a 'conditional formatting' rule.
https://help.smartsheet.com/learning-track/level-1-get-started/conditional-formatting
0
·
I believe you're looking to create a 'conditional formatting' rule.
https://help.smartsheet.com/learning-track/level-1-get-started/conditional-formatting
0
·
Yes, that worked, thank you so much!
I thought I would have to type out a formula but this was so much easier!
0
·
Hey!
You will be signed out in
60
seconds due to inactivity.
Click here to continue using the site.
Help Article Resources
Trending in Formulas and Functions
Formula help with adding up total $ in one column and associating it to the right business unit
I am having trouble coming up with the right formula for a sheet. I am referencing a sheet to create a formula in another sheet. In the sheet I am creating the formula in, I am trying to calculate (from the reference sheet) the cost by business unit. Here are the two columns I am trying to create the formula for: I need…
Need an equation to count text from a column with multiple selections
I'm having the issue of getting an equation to work properly in order to get a count on text in a drop down list of items. For example: I need to count how many times "Electrical" or "Paint" is mentioned in the same cell for the whole column. I keep getting error messages. The only equation that I could get to work would…
Forumula help to extra characters from a cell
Morning I am hoping someone has an idea how I can achieve the following I have a barcode which is formatted like this when scanned into Smartsheet (01)00843997014755(11)240401(21)700040293 What I need for example is when the barcode is scanned into lets say cell A, then automatically cell B,C and D will extra data from…
