-
Adding a Checkbox conditionally
I have a condition where I'd like to have a cell blank, until anything is entered into a cell on the same row. For example, if Column 1 is blank, there is no checkbox in Column 2. If any data is entered into Column 1, add a checkbox to Column 2. The difference being that if Column 1 is blank, and data is entered into…
-
Conditional Formatting to apply color to a cell with value after comparison
I would like to automatically apply color to a cell based on its value, as compared to another cell. I have a budget target in a comparison cell, and have a the budget actuals in the cell that needs to be colored in either red or green depending on it being above or under/on budget. Is that possible? I tried entering…
-
Conditional Formatting
Hi all, I have a sheet which has approx 55 columns, with alot of different data on, i need to set up conditional formatting to colour a cell yellow if it contains "TBC". I know i can set conditional formatting, but its a long and tedious task to do it per column. Is there a way that i can set up conditional formatting for…
-
COUNTIF/AND/THEN CHECK A BOX OR SYMBOL
FORMULA 1-I need a formula that will "count 5" check boxes and a "contain" to either "check a box or a symbol."
-
Why does the symbol font has fixed size?
I am trying to make my RYG symbol a larger size (in my sheet, report & dashoard) but even if I changed it from for example font size 10 to 28, there is no difference in how it looks like. Is there anyone who can help or might have experienced the same and share what you did? Appreciate the responses. Thank you.
-
Highlight every 3rd Row in Smartsheet
I'm working on a project where every 3rd visit a report is due. I was wondering if it's possible to format my table so that once the 3rd row is added, the row is highlighted.
-
Calculating time passed from one column to another
I would like to calculate time passed from a Start Column '00:00' to an End Column '17:00' for example This 'Overtime Hours' should be automatic, right now I have to fill it myself.
-
Calculating date variance between 2 cells only when both cells are populated?
Here is my formula that is not working. I would appreciate any help:
-
Text Decoration in Higher-Priority Conditional Formatting Rules
Current state example: Two conditional formatting rules. The lower-priority one sets font weight to bold. The higher-priority one sets font weight to normal (not bold). The result, in a row that triggers both rules, is that the font weight remains bold. It is not overridden by the higher-priority rule. Desired state: The…
-
Merged: More Color Options for Background and Text (Grid and Conditional Formatting)
This discussion has been merged.
