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)
We had a licensed user delete several files before leaving our organization. All of the sheets he owned have been transferred to someone else. However, there was one form we could not retrieve - Themed/Research Session Submission Form. Is there a way to recover that form? Any help is appreciated. Beverly Vance AMATYC…
Is there a way to save as a backup all sheets and workspaces? I am able to create a backup for all of the files shared with me. As the account's admin, can I back up all of the sheets and workspaces by all of our licensed users - even if they are not shared with me. We recently had a licensed use delete sheets and…
Hello all, I have a weekly report that I'm building and would like to be able to only expose two weeks worth of status. The report has a status and a commit date column and I'd like to remove anything that is "Done" and more than 2 weeks old. I'm trying to avoid having a report that has 100 rows of tasks that have been…
