-
Symbols for Multiple Columns or Adding Conditional Formating
Hi, Is there a way smartsheet can make it easier to apply conditional fomulas on multiple rows that meet the "N" = red and "Y" = green, rather than having only a format that can let me select multiple columns to the same color when 1 column has a "N" and setting a new rule each time I want to have "N" be red in a different…
-
Merged: Headers and sums fields in report exports
This discussion has been merged.
-
Merged: Formatting for Report Headings / Groups
This discussion has been merged.
-
Is there a way to ONLY have one cell unlocked?
Hi all, I have created a sheet full of formulas that ALL reference one cell. I would like to lock down everything BUT that one cell, so functionally anyone with access could change the reference cell and see the consequence of that change. I realize that I COULD move this one reference cell into its own column, but before…
-
Add HTML formatting in Automation Workflow Notifications
Would be great if we could force wrap text within an Automated Workflow Notification Alert "Message" using </br> HTML tags, and/or be able to <bold> text directly within the Message we're setting up. Hoping this can be an enhancement one day to Smartsheet.
-
Uploading Additional Fonts
Re-opening someone else's old enhancement request - We would love to be able to select from a wider variety of fonts, and especially have the ability to upload our own. Edit: This was meant to go into enhancement requests but I think I added it to the normal forums, I apologize! 😓
-
How to Format Date-dependent Color-changing Cells (3 total columns)
I need to create a Smartsheet for tracking documents, the date of last review and a color changing column reflecting the date of next review. In column A I need to list the document names. In column B I need to list the date of last review. I need help to format column C cells. 1. I need for Column C to populate a date…
-
How do I populate dates from a date column into my date formula?
I'm running a Countif function that counts production between two dates, currently my formula looks something like this: =COUNTIFS({Reference Column}, <=DATE(2024, 1, 5), {Reference Column}, >=DATE(2024, 1, 1)). For the date part of my formula, is there any way to input dates from two date columns so that I don't manually…
-
Conditional Formatting - Dates in the past
Hi, I want to add a conditional format on a column holding dates that will highlight those dates which are over three years ago. I thought I would be able to pick "is not in the last (days)" and enter 1095, however it only shows "is in the last (days)" For now I have had to add two conditions: "is in the past" AND "is less…
-
Merged: Sheet Summary Field - Add Format Painter Tool
This discussion has been merged.
