-
Conditional Formatting Based on 2 Different Cells
I have done this in Excel but can’t seem to get it to work in SS. I need conditional formatting to represent the following: EAC Margin < BL Margin BL Margin ≤ EAC Margin ≥ (BL Margin + 5%) (BL Margin +5%) < EAC Margin Tried creating a separate column with a formula using IF. But can’t seem to get the formula to work. I am…
-
Using AND and ISBLANK in nested IF statement
I am responsible for tracking my companies incoming inquires and quotes. Did we get back to everyone, quote them, did they accept or decline the quote?, etc. As part of that I sweated out the following formula, =IF(ISBLANK([Follow Up Date]98), IF((TODAY() - Created98) - 2 > 0, IF(OR([Quote Accepted]98, [Quote Rejected]98,…
-
Time stamped entries
Hi All, Is there a way to create a column with time stamp entries like the comments section? I want to make a highly visible column of entries that show when the entries were made. Right now the comments column can not be renamed or even copied. Regards Tony
-
Lead time Formula
Hello, I'm trying to figure out a formula or a way to make 2 cells work together and have the results in a third one. Here is the situation. this sheet is for procurement of items and their lead time to order. Example: in one cell we would put the date we would like the item to arrive onsite and in another cell we would…
-
API to apply conditional formatting
I am not able to find how to apply condiional formatting via API. I have various sheets that I want to update all at once and apply different conditional formatting without having to do it via the interface manually.
-
Conditional Formatting Key or Legend
We use conditional formatting for our master training calendar to show which training is for which audience. I have been asked to provide a "key" that shows what each of the colors represents on the calendar, but I haven't been able to find an easy way to do this. Any ideas are welcome and appreciated!
-
New Feature Request for Coments
It would be helpful if there was a way to flag a comment as complete. I would like to see a way to turn the Comment box for a row green (or any color) if the Comment has been completed or resolved. This feature would be very helpful for me to see quickly which rows or Comments needed to still be addressed. I am a very…
-
Apply Conditional Formatting to a Workspace
Is there a way to apply conditional formatting to an entire workspace, when sheets are identical in set-up, column type and layout? Thanks
-
Linking cells from multiple sheets to a report
Let me describe what we're doing: We are an agency that has several creative agents working on projects for our clients. Each creative logs hours worked on projects. We need to be able to count the total hours worked by all agents, then report that to the client report in one cell. Does that make sense? So if we have 5…
-
Card View: Color Cards Automatically Based on Parent
Is there anyway to color cards based on the parent task? I can't seem to do this in conditional formatting and was hoping to find another way.
