-
How to turn off >30 Flag
I have a flag that turns on >30 days after receipt of a document but what I did not realize is the flag applies to all documents >30 days old, even if complete. What I need is a flag that only activates when two Document Stages are active -- "In Progress" and "Contracting (Customer Review)" the other stages will not apply.…
-
Average of duration
Hi, does anyone know if it is possible to calculate the average of data in a column displaying a duration? They are expressed as 3d, 5d, etc. and therefore it won't let me calculate the average as it doesn't seem to recognize them as numbers. Thanks, Barbara
-
Formula
Please disregard. I have figured it out! I am trying to write a formula that will yield in the SUM = Y - (A + B) Looks like something is not right with the placements of the parenthesis. How to write this formula corrected? Thanks! Tali
-
Health formula help
Hi all, Can anyone tell me what is wrong with my formula: =IF(Status@row = "Complete", "Green", IF(Status@row = "[On Hold]", "Gray", IF(Finish@row <> "", IF(Finish@row < TODAY(), "Red", IF(Finish@row <= TODAY(5), "Yellow", IF(Finish@row >= TODAY(1), "Green")))))) All is working aside from the gray ball if on hold is not…
-
Logic to send a reminder 2 days before the first Monday of every month.
If I want to send a form to a list of users 2 days before the first Monday of every month will this logic work?
-
COUNTIF Formula for Contact Column
Hello Community, I have a formula setup to count the number of times a contact is mentioned in another sheet, but it is not counting the rows with multiple contacts in the cell. Is there any way we can workaround this to count every time the contact is mentioned, even when it's multiple contacts in a cell? My current…
-
Automate 'Previous Week Update' information from one sheet to another....options.
Trying to find an automated way to pull data from one cell to another so I can then reference it as 'Previous Week' back on the main sheet. For example: Sheet 1 will have a column named 'Key Activities Completed this Week'. I'd like that information weekly to be copied to another sheet. I'll then reference this cell in the…
-
Replacing Cells when row is moved to another sheet?
Here you will see my columns, and my archive (2nd sheet) is the same, i have an automation that basically says when the next recurring date has populated and it is -2 days old to move that over to my main sheet, and that is working for me. My question is, is there an automation or a formula where when it is moved back to…
-
Gridline colors
Have you considered the option to toggle the gridlines from the current gray to black as well as toggle on/off the vertical gridlines? On some monitors the gray lines fade out which makes it difficult to read. I didn't know what category to select because I didn't see one related to product enhancements.
-
Formula countifs mulitiple criterion?
Hi, I can get as far as (made up example) =COUNTIFS({Range 6}, "bdgl-1", {Range 5}, "pass") but I need to get a third items to be count. For example: =COUNTIFS({Range 6}, "bdgl-1", {Range 5}, "pass", {Range 8}, "ready") Is it possible to search three different columns in a crossheet countifs? Thank you, I appreciate any…