-
alert with specific row
How can I set up to send an alert for specific row when it matched a condition . I tested it and it triggers correctly but always send the first row. for example, it should send out the 10/10/2022 row only, but it sends out 10/2/2022 row any idea? Thank you
-
Highlight a specific cell not the entire column/row
I'm looking to only have child rows highlighted when the value is greater than one. Currently conditional formatting only allows for applying a format to an entire row, or to all the cells within a column (Parent + Child) are there any formulas I can embed in a child row cell that will only highlight for that specific cell?
-
Remove conditional formatting
Can I remove conditional formatting from a cell? I've built a plan with multiple dates for action steps in columns for each row and need to lean on CF to highlight late and upcoming activities. Once the activity is completed, removing the cell color (or remove CP) would help indicate that its "completed". Thank you
-
Is there a conditional formatting rule that shows if a date is more than X years in the past?
I have a sheet where I would like one column of dates to be conditionally formatted to show if the date is greater than 5 years in the past. I can only find the function for "in the past" without any way to add to the formula how far in the past. Is it possible to set parameters on past dates? It seems like this should be…
-
Last value of a row that is not empty
Hello everyone, I have to make a milestone tracker that I update week by week by adding a new column (the rows are the projects). I can't just modify a column because they require me to keep a history of the data. columns (date type) can contain a value or be empty. I need to get the last updated date for each project (not…
-
Conditioning logic to be AND not OR in form
Hi there, I am needing to build in logic to a form whereby a question shows if a specific answer to 1 AND 2 is selected and not OR. Question 1 : A, B or C Question 2: X, Y or Z Question 3: Appears if answer to Q1 is C and answer to Q2 is Y. Currently this is showing if answer to Q1 is C or if answer to Q2 is Y. I need it…
-
Conditional Formatting Referencing Other Sheets
Hello, I'm building a process and want to add some automations to minimize errors. I have a column for "partner" that is a filled in via a form on sheet 1. I have a list of partners that we do not work with in sheet 2. I would like for the row (or cell) in sheet 1 to change colors if the form response is one of the names…
-
How to put in exact dates when tasks have predecessors linked
I have all my tasks linked to predecessors so that dates adjust correctly, but I am now unable to change the date to something farther down the line unless I unlink everything. Does anyone have an idea of how to fix that? Thanks
-
Conditional Formatting Cloning
Hi SS Community, I have a colleague who has a sheet with a ton of CF rules (which are applied to months/years ie. June 22, Jul 22, Aug 22, etc). He would like to clone a rule and then change the "condition" part to different month so the same formatting will apply without having to manually re-enter the rule. ie. If " Test…
-
IF formula for multiple dropdown values?
Newer user, I'm having trouble finding how to properly format... One column, [RGU Sold], contains a variety of sale, no sale, and customer interaction options. I would like to create a conditional formula that groups those responses to yield "sale", "no sale", "following up", or remain blank if there is no value. Multiple…
