-
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…
-
Reference Sheet Summary data from another sheet
Currently if I could like to reference another sheet in either a cell or in a formula elsewhere, that data must come from a sheet and not a sheet summary. This means I have some data duplicated in a sheet summary for a report, and also in a sheet for use in a reference elsewhere
-
Use a formula to change the row's health
In a schedule, I'm trying to change the row's health to "red" when the current date is past the "Finish" date and the task is less then 100% complete. I can't get the formula to work when I try to make use of the "% Complete" column. Here is what I'm trying: =IF(AND(Finish@row < TODAY(), [% Complete]@row <> "100"), "Red",…
