-
Re: Introducing the 2023 Core Product Certification Exam + Community Badges
I second LizTo's comment. I passed the exam, but felt like I either overthought or there were some trick questions. I would have loved to have been able to review and learn from the questions I got w…1 · -
Re: Countifs formula to count tasks in a range last 7 days to future 7 days
Looks like you have a misplace parentheses. Try this: =COUNTIFS({Owner}, "Joe", {Status}, "In Progress", {Due}, >= TODAY(-7), {Due}, <= TODAY(+7)) Hope this helps!:)1 · -
Re: Formula to Summarize spending each week to display in a Dashboard
First of all, it looks like your dashboard widget is sorting dates in the same order that your report is set up to sort. You should be able to just sort the dates in the sort tab on your source repor…1 · -
Re: My IF nesting formula is not working
It looks like you put your closed parentheses on the AND statement too early. Try this: =IF(AND(Status@row = "Completed", [Remaining Amount]@row = "0", OR([Payment Status]@row = &…1 · -
Re: March Question of the Month - Join the conversation and receive a badge
Oh my goodness! There's so many great songs across the genres for getting in the zone. If I need to do a lot of critical thinking or working with my words, there's usually an intense soundtrack playl…7 ·