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)…
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". =COUNTI…
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 as…
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 (partiall…
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 sh…
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 = "", [Fir…
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…
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:
Greetings, I'm attempting to sum the number of project management hours for the project managers in my function for given points in time to generate a capacity forecast for 2024. I'm currently buildin…