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)
Hi everyone, Quick question about sharing permissions in Smartsheet: If I share a specific sheet only (not the entire workspace) with someone as a Viewer, will they be able to: See the list of people who have access to the workspace itself? See the names of other people who are shared on that same sheet (the collaborators…
I'm on the bussiness plan. We have 8 team leaders who are licensed users on the legacy model. Other people on the organization are collaborators who occasionally update task status and comment on rows. This updates are sometimes done through forms and sometimes directly on the grid view. We also have people from outside…
Hi Team, I notice when I initially submit an email from the Dynamic View to the submitter, a notification isn't triggered to them of my comments, but I receive an email when the submitter replies back to me. I had the submitter check their spam and junk folders for my email, but it wasn't available. Is there a solution for…
