-
Pull date from text string for conditional formatting
I have a text string column that always ends with "by [date]" on a sheet that someone else manages. They want to keep the text in that paragraph instead of using a separate date column, but they want conditional formatting on the date column… I have a formula that pulls the text value from the Next Deliverable(s) column:…
-
Changing Colors - Card View
I can't figure out why the colors aren't showing up in card view with conditional formatting. It's working fine on grid view and table view. I have tried coloring everything or just the status, and "high priority" items should have red text. When I go to board view, it tells me to go to card view to change the conditional…
-
Conditional Formatting Based on Min & Max Columns
I have a sheet that shows the stock of all promotional items across several locations and I'm trying to set up conditional formatting to highlight the cell if it's less than or equal to the min amount. I can do this manually for every row but wondering if there's a way to do this similar to how excel & Google sheets have…
-
Conditional Formatting
Hi all, and thanks in advance. I was trying to do a Conditional Format on this. I know how to do it in Excel, as I would use a formula, but I am having trouble with only the dropdown choices available. Okay, I want my CF to check if the 2 circled columns are the same. This instance does not show, however basically I am…
-
SIMPLE Conditional Formatting is not Working
I have never had issues with conditional formatting, even when formulas were required. This one is simple, it is NO formulas, just based on the user's selection from a dropdown that appears in this sheet. The first screenshot shows the column example. Most are declined here, and those should be highlighted ORANGE based on…
-
why are theses column not being colored not by conditional format or by me ?
-
RACSI/RACI Matrix with Conditional Formatting
Does anyone have a solution to easily set up conditional format for a RACSI/RACI Matrix without having to clone each RACSI option and setting up a conditional format for each role (in columns)? Like a formula or selecting multiple columns with the same dropdown? I created a traditional RACSI matrix for a customer but got…
-
Highlight new row
I have an automation that copies over a row each time it meets a criteria. is there a way to highlight the newly added row in the destination sheet by automation/conditional formatting?
-
Numbers in Form
My Regional Number Settings are: 2 500,00. In the Form, I have a field that only allows numbers. Form input rows to the worksheet. Unfortunately, the Form doesn't allow the "," entry. In the Form, the number must be entered as 2500.00. However, such a value transfered to the column (with setting as Text/number) in…
-
"Does Not Contain" Conditional Formatting
It just came to my attention that the custom criteria dropdown for Conditional Formatting has a "contains" option, but not a "does not contain" option. Also, the "Apply to format when condition is NOT met" button [which would solve this problem] only exists on the "select from a list" menu and not from the "define custom…
-
Sheet Timeout & Performance Issues – Identical Copy Works Fine, Original Doesn’t
Hi everyone, I’m currently working with a Smartsheet that includes: ~30 conditional formatting rules ~1700 rows Multiple columns with INDEX/MATCH formulas Numerous columns with regular @cell formulas Numerous columns with various types of data Two Data Shuttle workflows that update dropdown values in two columns Multiple…
-
Change formatting based on new date input
Background Currently, I am tracking whether a person attended a visit on a certain date and color coding for easy reference. Each row represents a person These dates are at regular intervals, so I'm using a column formula to calculate what the dates should with each each column referencing the column before it as long as…
-
How do I get my datasheet to show the months requests were opened and closed
when my request tracker sheet's input is in calendar format? Current set up is as below, and I'd only like to use data from column A & B to ensure better accuracy in the data sheet:
-
Conditional formatting randomly not working
I am trying to determine why the conditional formatting has stopped being applied to random cells. I have the settings set to change as we change the drop down option. However there are random cells that the background formating is not applied and you see the words. It is random. I have cleared formating. Deleted the…
-
Conditional Formatting for Proof Approvals
Would be great if once all parties have approved a proof (using the built in proof approval feature), conditional formatting can be applied to a row. This way we don't have to go in and manually check the status on who has approved each line item. I haven't found a way to do this and have viewed a lot of forums. If anyone…
-
Conditional Formating
I have a column where multiple values can be selected. When "A" is selected certain other columns are blacked out. I want to have a rule that when "B" is also selected a few of those columns that were previously blacked out become normal again. However, when I try to create the rule for "B" it removes the rest of the…
-
Formula help to convert from total days to business days
I have this formula which gives me the total # of days to complete a construction interval, =IF(NOT(ISBLANK([Construction in Progress Date]@row)), ([Into Pending Lateral Date]@row - [Construction in Progress Date]@row)) How can I convert this to business/work days total?
-
Mysterious strikethrough being added during automation process?
Sheet 1: team manually enters weekly updates to dates and metrics Sheet 1 Automation: weekly Friday morning trigger to copy all rows (~5-15 rows) from Sheet 1 to Sheet 2 Sheet 2: ledger of all updates made week to week Report: Pulls in Sheet 2 from 12 projects, displays 8 columns, filtered down to just the prior 2 week's…
-
How to Automate Email to the Submitter?
I'm trying to set up an automation that will email the submitter once their request has been set to a status called "Approved". I made a Contact list column for the submitter to enter their own email, but when testing this automation, the submitter never got an email. Any help with this would be greatly appreciated!
-
Conditional Formatting Combined with Dropdowns and Dates
Hello! I have a user tracking the progression of course development and is asking if there is a way to do some formatting on his sheet. The columns shown are set up as dropdowns (there are 8 total columns on this sheet). In the yellow row, in the cells where I've drawn a box, he is going to place due dates. Is it possible…