-
Using sumifs to return date value in a date value column
I need help with the formula for returning the date text from a date column if certain criteria is met. =SUMIFS(Date526:Date1045, Day526:Day1045, "MON", [WK #]526:[WK #]1045, [Miss Unavoidable]2616) The formula seems to work but doesn't return a value in the cell.
-
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 OR Criteria
Hello community, I am looking to add the OR function, but I am having no luck doing so. I need to add the criteria: {Func} = "Paint" to the following formula: =COUNTIFS({Func}, "Building", {Loss Date}, MONTH(@cell) = $Months@row) Thank you, Ron
-
If/Then formula
Column = 2023 Calendar Savings Column = Confidence, which could be 25, 50, 75 or 100 If Confidence = 25 then multiply 2023 calendar savings by .25 then if Confidence = 50 then multiply 2023 calendar savings by .50 etc
-
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…
-
Auto populate date column when column is checked off formula
Hello! I need help figuring out a formula for the following... 1 - Date Column Title: Handoff Date 2 - Dropdown Column Title: Onboarding Progress Essentially, when the status of the 'Onboarding Progress' reaches "handed off to qualification" and is checked off in the dropdown column...is there a formula that will…
-
Auto checkbox formula for a date
I'm looking to have a checkbox column be automatically checked off whenever the date column next to it is filled in...here are the two column names: SQV Scheduled - checkbox formula SQV Date - date column (next to it) This is the formula I have: =IF(ISDATE([SQV Date]@row, 1, 0)) It's not working :( help!
-
Parent row possibility?
I have an idea but I'm not sure it's possible, need some advice. I have a form I've created with an option to add 5 submissions. I need to be able to total these submissions based on who filled out the form. Right now I have a helper column that adds the submissions up that are on the row, but I wondered if I couldn't set…
