-
Help getting the summary of my sheet
I am not getting the result I need from a formula I am using. I am trying to track how many audits are completed and how many are left to do in total for this quarter '__ of ___ done', currently I am using this formula: =COUNTIF(CHILDREN(Done2:Done130), 1) + " of " + COUNT(CHILDREN([Task Name]2:[Task Name]130)) + "" + "…
-
how to alert contacts in the row when the Planned date is about to reach?
What process should we use to automatically alert the contacts in that row about the status 3 days before the PP planned date?
-
How to highlight the values in the column which is greater than or less than the other column values
Suppose, the order quantity we have taken from the customer is 500, and the quantity we have placed an order with our supplier is 600 how to highlight this excess quantity?
-
Convert date field to month text
Hello! My goal: 01/02/2024 returns a value of January or January 2024 in another cell The column that contains 01/02/2024 is a formula calculating this date. I need to show the month (and year if possible) in text in another column. Is this even possible?
-
Conditional Formatting Condition Pop-Up: Expandable Window or Mouseover Reveal for Long Column Names
Currently, the "Set Condition" pop-up window in Conditional Formatting does not distinguish longer field names that share prepend naming conventions (the first 30-ish characters being shared / identical). Two methods that are available elsewhere in the platform, expanding the size of the pop-up window or hovering mouseover…
-
Need Help With COUNTIFS OR Formula.
=COUNTIFS([Timeline Prioritization]:[Timeline Prioritization], "Now (1/1/24-5/31/24)", [System Status]:[System Status], "In Progress") That formula is to count the number of cells that have "Now (1/1/24-5/31/24)" in the Timeline Prioritization column while also have "In Progress" in the System Status column. Based on the…
-
Merged: Conditional Formatting Referencing Other Columns
This discussion has been merged.
-
Conditional Formatting Grid vs. Card View
Hi - I tried to set up conditional formatting for a new sheet. I've done this with other sheets with no problem. I want to color by category (entire row). however, the colors are not showing up in Grid view, only Card view. I have no idea why this is happening. I thought it might be in the settings but it doesn't appear I…
-
How to Sum (Distinct Value Column 1 * the Qty in the same Row) + the Count of distinct in Column1
I am trying to create a formula that will Sum the (Distinct Value from Column 1* the Qty in the same Row) + the Count of distinct values in Column1 for a total to be calculated in another Sheet next to the Distinct value. There may be an easier or more straight forward way to do this but I am not sure. Below is an example…
-
PSA: Conditional Formatting Stopped Working
I went through hell trying to figure out what is causing my conditional formatting to suddenly stop working when it was working perfectly in the past. My sheet is shared by 104 people. After many hours scratching my head and calling support we figured out the issue. SOMEONE TURNED ON HIGHLIGHT CHANGES and made the…