Hello, I am developing metrics for a group at my company and need some help. They do not log when they mark something as complete by date just by status. The date of the status change is in the cell h…
Hello, Trying to recreate a formula i wrote in a previous role to track duration for a monthly average. My formula is written as so: =IFERROR(SUMIFS({Duration}, {Duration}, ISNUMBER(@cell), {End}, ISD…
Hello, I have been out of the game for a bit and having trouble writing this formula. Trying to collect monthly data for completed calls. Currently I have my formula written as this: =COUNTIFS({Status…
Hello! I need some help putting together a formula to track year to date renewal increases. My criteria is Underwriting Status needs to be set at "Completed Increase" and i need the sum of all the rat…
Hello, I have a co-worker who is having trouble letting her colleagues view current and past edits to the documents she is working on in Brandfolder, this is all under the Proofs feature. Is there a s…
Hello All! Need some help have no clue where to start. I have been tasked to create some metrics around turn around times. What i would like to show are things like Average Turnaround Time. Values wou…
Hello, I am trying to see the total # of submissions through our intake form that are not designated for Product Management. This is how I currently have my formula written. Not sure what I am doing w…
I need to show the average of an {Initiation Duration} by each month. So average for Jan, Feb, March, etc. Columns Initiation Start (Date Column) Initiation End (Date Column) Initiation Duration (text…
Hello, I am trying to run a duration formula based on the start and end dates on a project and the estimated dates. The estimate dates are how long we think the project will take, the start and end ar…
Hello, I need to count status values which reside in the same column that are related to a specific track. I think I need to add OR( in the formula but am not sure how that is formatted. My current fo…