-
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 in conditional formatting
This discussion has been merged.
-
Convert to Column Formula grayed out
I'm trying to use Conditional Formatting on a Status column to change the color of the bubble based on the value of the Stage. I'm using the following and the option for Convert to Column Formula is grayed out: IF([Stage]@row = 'Not Started', "Gray", IF(AND([Stage]@row = 'Testing'), "Yellow", IF(AND([Stage]@row ='Done'),…
-
Integrate with Outlook with Dates and Times and Assignee Information
The outlook integration as it exists is nice if you only have one or two projects. As a single user I manage hundreds of projects at a time I would like to be able to sync my calendar to outlook in a more integrated format. For example, when i set a task or appointment date in Smartsheet I would like to be able to…
-
Linking Sheets in Workspace, Cell Pull through based on conditions
I am creating a series of sheets in a workspace. The idea is that there is one master log that feeds other logs as it is updated. The child logs would be fed once a condition on the master log is met, the kicker is that I don't want a line for line transfer leaving me with blank lines if a line on the master log has not…