Conditional Formatting
Discussion List
-
Frozen/Unresponsive SheetsIn Using SmartsheetWe're experiencing freezing/unresponsive sheets after a few moments of being open. This has been going on for a few days. Anyone else experiencing this? Thanks
-
Edit contact display?In Using SmartsheetHi Do you know if you can edit the display of a contact in an assigned to column? Ideally I just want to see the initials in the icon and not the name/ email that follows. Thanks, Jo
-
Conditional Formatting - One rule on multiple columnsIn Using SmartsheetHello, To make our Smartsheets more legible when used for input requests, we use conditional formatting. For example, if we have a table used for percentage-splits with 12 columns and 100 rows we generally pre-populate these inputs wher…
-
When can we expect an expanded color palette for Sheets?In Using SmartsheetCurrently in Sheets for background fill and fonts, there is only the option of 5 shades of 8 basic colors as shown below. When can we expect this to be expanded to a full hex palette like for charts in Dashboards?
-
Percent Formatting applied, but entry of 100 is shown as 10,000%In Using SmartsheetI have the entire column formatted as a percent, but when I enter 100, it shows as 10,000%, or when I enter 1 it shows 100%. Would like for the number entered to show that percent.
-
CountIf for check boxesIn Formulas and FunctionsGood afternoon, Can you do a Countif formula for a column that has checkboxes.....so that you can count how many rows have the check box? Thanks
-
Format as timeIn Using SmartsheetI need to keep accurate documentation of how long my deliveries take (down to the minute) I normally do this in spreadsheets by having the column formatted as a time. I cannot see that option in the formatting list. Am I blind or is it not…
-
How do I auto-save a sheet without opening the sheet?In Using SmartsheetI use conditional formatting. When I review the dashboard, the formatting doesn't update until I go to the sheet and save. I would like the sheet to save automatically when conditional formatting makes changes. Thank You.Answered - Pending Review 244 views 17 comments 1 point Most recent by Andrée Starå Using Smartsheet
-
Forms that need to incorporate multiple line entriesIn Formulas and FunctionsWe currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible As you can see from the attached files, the form is set up to add a new line after each previous line is fi…
-
Highlighting duplicate data based on two conditionsIn Formulas and FunctionsHi, I want to make a formula to highlight whenever to cells contain the same data on the same date. I'm working with a marketing calendar and want to find a way to highlight whenever two campaigns are planned to go out to the same country…
