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)) + "" + "…
What process should we use to automatically alert the contacts in that row about the status 3 days before the PP planned date?
It would be helpful to be able to do conditional formatting for the entire sheet or by a row rather than column by column. It becomes very tedious to enter the same formatting over many columns.
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?
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?
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…
If I want to apply a conditional format to Column B on the proviso that Column B is greater than Column A, I must use a Helper Cell to determine if this is True or not. Like Microsoft Excel does; by including the ability to specify a formula to ascertain whether a Format should be applied would be a lot cleaner than having…
=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…
I would like to see conditional formatting rules that can be applied to other columns. For example, we have two columns for each of our KPIs. One column reports the target turnaround timeframe. The other column reports the actual # of days it takes to complete an item. For our surveys, our target turnaround timeframe…
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…