Comments
-
Danielle, thanks this helped tremendously. Im also trying to show hours over based on $30 per hour. Is that even possible?
-
Julie, just when I think I had it. I did a test sheet like your example and it worked perfectly like your example, but when I pulled it from another sheet it came back as unparsable I did =COUNTIFS({Test sheet Range 1}:{Test sheet Range 1},IFERROR(MONTH(@cell), 0) =1,{Test sheet Range 2}:{Test sheet Range 2},"Won").
-
thanks for the tip Kelly it was my numbering that caused the issued. Its been resolved
-
this is the sheet that Im pulling it into. I copied it from the sheet thats in white below. Im using the autonumbering function on the origin sheet.
-
thanks for the tip on reporting. I cant seem to get it to appear correctly on the dashboard. I had created a formula for total # of jobs per month and a formula for those that are completed in separate reports. I was hoping to combined the two formulas, I tried to combine the two formulas but its not quite working for me.…
-
I have date columns as 5/31/23 columns as well as month/year columns 5 2023