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)
Hello, I am having trouble making my Dynamic View work. I feel like I am following the instructions but I seem to be the only one able to see the "view". Trying to test this internally before I push out to the customer. I am using a filter that is built into the main worksheet. Anyone have time to review with me? Thank you…
I’m having service provide agreements for different clients, how to implement a e-sign workflow in smart sheet where a document is generated and sent for signature to the clients.
We have MANY sheets to transfer. This is as a result of our company domain changed (hii-tsd.com to hii.com). So we transferred ownership to 3 people (myself included) on the Portal Team, who manage the Smartsheet files. I had a co-worker on the portal ACCEPT the email that was sent to the shared mailbox, and then the…
