-
Renumbering Children
I am trying to figure out how to set up a column that would set a child's number. If the parent has 5 children then the numbering would be 1-5. If you inserted a child between 2 & 3 then that new record would become 3 and the rest would be 4-6. I know I have to count the children but I am not sure how to identifies the…
-
Formula help with multiple variables
I would like to use a different sheet to aggregate data for the purposes of creating a dashboard. I am trying to determine the number of minutes a person spends on a specific task for a specific month. For example, I would like to know how many minutes Jane spent on emails in the month of January. Sheet column headers are:…
-
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"
