-
Visual Status Alert
Hello All! I hope this is an easy soulution. Can anyone assist me with creating at status alert based off of today's date and a start date? I want the Delay Status to automatically put the status listed and color the cell. If a Cleard to Start has a check mark, then it shows no delays and color coded green. At some point,…
-
Edit contact display?
Hi 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 not applying to entire column, even with helper column added
Hi - I have a colleague who has a sheet with conditional formatting that turns the cell and text in a particular column GREEN if the date is within the last 31 days. As you can see below, only half the conditional formatting not applying to certain rows. I've gone and done the "helper column" trick and tried it that way,…
-
Set Target End Date first and have predecessors fill in
Is there a way to set the Target End date in a project sheet first and have all the preceding dates backfill? When I tried it, an alert comes up that says "…will result in the removal of all predecessor relationships in this row". I've looked into the Workback Schedule using the Project with Hard Deadline and Gantt…
-
Document Builder: Conditional Formatting & Symbols
It would be great if document builder was able to: either apply conditional formatting within the builder or carry through conditional formatting from the source fields/sheets able to pull through field properties such as symbols as the graphical representation rather than the backend text e.g. I want to include project…
-
FORMULA: Conditionally Format Cells with Errors
This is unlikely possible with Smartsheet but I'd LOVE to be proven wrong :) I'm trying to Highlight Cells in the row that have errors. There might be one to twenty columns in that row with errors at any given time. Reason for it: One broken formula (or cell with bad data) can break several other formulas in that row. And…
-
Help with a formula
I am trying to get THe project column to auto populate with the "children" from the source sheet when the "sign Type" is selected.
-
Conditional Formatting on Sheet and Row Level
Dear Smartsheet Development Team, I hope this message finds you well. I am writing to suggest an enhancement to the conditional formatting features in Smartsheet. As a frequent user of your platform, I have found that while Smartsheet offers robust functionalities, there are limitations in the conditional formatting…
-
Merged: Apply conditional formatting to a range of Columns or Rows
This discussion has been merged.
-
Sheet - Format Cell Border
The ability to format cell borders with line style and color.
