嗨,我有一张约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…
FORMULA 1-I need a formula that will "count 5" check boxes and a "contain" to either "check a box or a symbol."
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.
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.
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.
Hi Team, How can we have a drop down in Dashboard My objective is - Say for a example a user want to see just the input related to his/her project he can filter his project from dashboard and view. Thanks
Here is my formula that is not working. I would appreciate any help:
Hello, I am very new to Smartsheet and I am working on a project tracking sheet. We have the following statuses in a cell: Unassigned; In Progress; Completed; Cancelled; On Hold When a request is submitted this automatically triggers a 'Created Date' column that logs the date/time of creation. I would like this to be…
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…
This discussion has been merged.
