-
Is it possible to update a contact list column based on a value in another cell?
Is it possible to update a contact list column based on a value in another cell using a formula? I am creating an assigned to contact list column with an end goal in mind of setting up a dynamic view based on setup specialist (my understanding is you can only set a user view based on a contact column). As you can see - I…
-
I want to count the number of times a contact appears in a column, how do I do that?
So, I started with =COUNTIF(Name:Name), FIND("John Smith", @cell) > 0) this produced #unparseable. My ultimate goal is to have a dashboard that will display a pie chart with total number of leads per person. Thanks for any help!
-
Making Negative Numbers Display as Zero
I am trying to calculate the number of working days between the due date and date received on a contract deliverable. The formula works great when the contract deliverable is received on time or after the due date. The problem I am having is if the contractor submits the deliverable early (prior to its due date) it is…
-
Is there a way to write a formula to uncheck the box in one column IF another column has a checkmark
I am wondering if there is a simple formula that will uncheck a box in one column if a second column is checked. I am sure it is a really easy formula but I am drawing a blank. Thanks.
-
Need Help with Duration (days)
Hi guys, I am setting up a dashboard and trying to collect data for it. I would like to show average duration for projects, if possible. For example, I have the columns below. Is it possible to create a formula that will tell me an average length from received to approved? Or do I need to add an actual “Days” column into…
-
Help needed with formula calculating open issues based on status, owner and due date
The formula is not pulling all data. Below are the formulas I am using: Overdue: =COUNTIFS({Status}, "In Process", {Assigned to}, "Susan Hacker", {Current Completion Date}, <TODAY(0)) Due in 1 month: =COUNTIFS({Status}, "In Process", {Assigned to}, "Susan Hacker", {Current Completion Date}, <=TODAY(30), {Current Completion…
-
Formula to indicate previous and next months
I'm drawing a blank on how to achieve something to avoid having to manually maintain a sheet. I've got a main data sheet with new requests getting populated. They have dates associated with them and what I'm doing is pulling them into another sheet to summarize that data based on the month. This piece is working great with…
-
COUNTIF / HAS / AND - How to count multiple selections in the same column.
Hello to All, I am trying to count items in a column. I have the formula in place for all inpatient and another formula for ambulatory. I need a count for those that have selected inpatient AND Ambulatory, basically how many selected both locations. This is what I have tried: =COUNTIF(Location:Location, HAS(@cell,…
-
Index and Match formula issue
Hi All, My colleague and I are trying to find the first occurrence of non-zero in a table and then return the corresponding month. Example table The formula that we are trying to work with is below, but whatever we try we keep getting an error of #UNPARSEABLE =IFERROR(INDEX(January31:December31, MATCH(True,…
-
Date Function
Hello, I need to record prior dates in the following 3 date fields which is based on the date column. Can someone kindly share how to write a function for this and explain it? It is a possibility that I may have to included a 90 days prior field and I want to make sure I understand the formula enough to know where changes…