-
Count Summary Formula Question
Hello, Can anyone tell me what formula I would use if I want to count certain criteria based on criteria in another column? I want to be able to add tiles to my dashboard the number of internal and client meetings based on if the client confirmed. I have a column for Confirmed by client - Yes/No I have another column for…
-
Countifs with multiple criteria and a "combo" criteria
Hi! I am trying to figure out what I am doing wrong with the below...the formula works until I add the last part "=date(2023,3,14+{Sprint Push}, 1" =COUNTIFS({Target Complete}, =DATE(2023, 3, 28), {Parent/Header Column}, 0, {Early/Late Complete}, "", {Target Complete}, =DATE(2023, 3, 14) + {Sprint Push}, 1) I want to count…
-
How can I write a countif formula formula for a cell that contains multiple entries?
I have been struggling to get a countifs formula to match what I've created on a report so that I can display it on a dashboard. I want to count the number of times our team has had a call on specific topic with our clients. In some cases the conversation covers multiple topics and we log what was covered on the call over…
-
Formula not Pulling Time Stamp Time post 7:00PM Central Standard, Why?
I have a [Time] Column with a formula that uses SUBSTITUTE() and DATEONLY() to pull only the time from a timestamp column. =SUBSTITUTE([Start Time (Timestamp)]@row, DATEONLY([Start Time (Timestamp)]@row), "") It works fine for any timestamp that occurs prior to 7:00PM, after that time, it pulls the date as well. I also…
-
Do we have anything similar to Excel Blog, where new formula or updates are posted?
https://techcommunity.microsoft.com/t5/excel-blog/bg-p/ExcelBlog
-
Concatenate Integer + Words?
I work in events. I group my tasks by how many months out the task is from the event date (1 month out, 2 months out, etc.). I'm wondering how I can create the `1 month out from event` in field using a formula. I'm coming from the world of Airtable where I could calculate how many months a Due Date was from an Event Start…
-
COUNTM not working
Hello community, I have a formula to count distinct values in my column. However, it is not working how I'd like it to. This is the formula with the image below that it relates to: =COUNTM(DISTINCT([19th Mar]3:[19th Mar]60)) The number of counts is 5, but it should be 3 because 'FG' 'BK' are repeated. I assume it's not…
-
Count Day Between IF
I am looking to count the days between two columns, if a third column meets criteria. Compare Due Date and Collection Date, counting the days between if Test Type is "Random"
-
Countm Distinct formula for multiple dropdown column
When I use the countm(distinct()) formula, I get an answer of 4 instead of 3. This is a drop-down list with the option of having multiple values per cell. There are no extra spaces in my cells. The formula seems to know that there are 3 different options in the blue highlighted cell but is unable to see that the "K-S-212"…
-
Linking Two Sheets to update dynamically When columns are added and removed.
I have two sheets that i want to be linked dynamically. EX: Column 1: 1 2 3 4 5 I want to be able to have this column automatically update and be created on the second sheet when it is changed on the first. If for example, I were to add in a row between two and three with a value of 2.5, I would like this to update on…
