TPALJA·Scheduler·✭✭

Comments

  • Danielle, thanks this helped tremendously. Im also trying to show hours over based on $30 per hour. Is that even possible?
  • that worked! you made my day. I appreciate it!
    inFormula Comment byTPALJA 06/23/23
  • 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").
    inFormula Comment byTPALJA 06/23/23
  • Julie, that did it! I cant thank you enough!
    inFormula Comment byTPALJA 06/22/23
  • I tried using this =COUNTIFS({Date quote one}, IFERROR(MONTH(@cell), 0)=1), COUNTIFS({Quote Status}, "won" but it came back as unparseable
    inFormula Comment byTPALJA 06/22/23
  • 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
  • yes
    inFormulas Comment byTPALJA 05/26/23
Avatar