Sign in to join the conversation:
I am trying to calculate the sum of mcqs (# MCQs) for the course ID (Course) if they were contracted in November (Contracted Date) and the Completed box is NOT CHECKED (Completed).
Any help would be greatly appreciated!!
Give something like this a try...
=SUMIFS([# MCQs]:[# MCQs], Course:Course, "ID", [Contracted Date]:[Contracted Date], AND(IFERROR(MONTH(@cell), 0) = 11, IFERROR(YEAR(@cell), 0) = 2019), Completed:Completed, 0)
I am trying to pull together a view of my portfolio that takes 7 projects and pulls the milestones. I want to be able to have the seven projects each be able to expand/collapse individually, ideally from the dashboard, however, I'm having difficulty figuring this out. Seems like it is an all or nothing setup. I have my…
When selecting a contact from the dropdown list in a 'Contact list' type column (used to assign leads for tasks), only the email address appears in the cell when a contact is selected, but in the address book the name + surname and email address is listed for each person. How can this be fixed? Thanks
Does anyone know if there is a way to remove the blue boxes on the document building and format the text (bold, italics etc…)?
