-
CHECK BOX IF TWO CELLS MET THE CRITERIA
Hello, as you can see, I have a form and if a employee selected a certain date and certain time, what is the formula to tick or check the box on the circled part of the picture. Please share with me the formula. Thank you
-
Sum up values with #NO MATCH error
HI All, Some of the cells that I want to sum up are a "#NO MATCH" which is fine as those values are based on other formulas and there might be no value for them. Now, trying =SUM(IFERROR(Cellsrange,0)) is not working, its giving me "0" as a result which is incorrect.- see attached. Please help as its really painful doing…
-
Countifs Reference Another Sheet - Help
This is the formula I am trying to use with reference to another sheet. Range 5 I want to only count if ticket status is "resolved" and Range 6 if in the month of Dec 2023. Error "Unparsable". =COUNTIFS({Field EDI Request Sheet Range 5}, [TICKET STATUS], "RESOLVED", [{Field EDI Request Sheet Range 6}, (LAST STATUS DATE},…
-
Need to identify the current month plus the last 7 days of the prior month
Hi there, I have a helper column that checks the "Current Month" check box if the date is within the current month: I used this formula: =IF(MONTH(Date@row) = MONTH(TODAY()), 1) The business is now asking to identify when a date is in the current month or in the last 7 days of the previous month. For example, this month…
-
Calculate count based on certain criteria.
Using a helper column to either return a 1 based on certain criteria or greater than 1 based on countif. Then conditional formatting to highlight those that are >1 Current formula that works (partially): =IF(Sit@row = "NA", 1, COUNTIFS([School Name]:[School Name], [School Name]@row, Sit:Sit, Sit@row)) Returns a 1 if the…
-
How to pull data from one sheet column to another sheet column
I need a formula that will extract all data from the column A in sheet A and auto fill it in column B in sheet B when added in the source sheet. Sheet A will have different columns and info than in sheet B, needed only the auto pulling of the data from this one column.
-
Formula Check Box
Hi There, I need help with implementing "Checked" vs "unchecked" symbol into my formula. Online I saw " Checked" and "Unchecked" and that didn't work for me. My formula : =IF([Founder?]@row = "", [First Name]@row + " " + [Last Name]@row + " is a founder of " + [Name of Company]@row + ".", IF([Founder?]@row = "", [First…
-
Quick SUMIFS question - Additional Criteria is Date
Hello, I have a quick question for the formula gurus. I have two sheets, a Roster and Data sheet. My roster sheet is where I want to show the data and the Data sheet is just a collection form. My goal is to display a point total that only pulls points from the last two weeks (14 days). So this is my data sheet. As we can…
-
How do I get my events (recurring) to show up once a week in calendar view without manual input?
Here is the sheet with the two meetings that occur once a week: I want them to populate once a week automatically without manual inputs and to show in calendar view every week: