I would like to add up all the action items on my Action Item log that are Past Due so I can show this on my project dashboard. How do I construct the COUNTIF statement to achieve this?
Thank you from the newbie!
I don't use COUNTIF, only COUNTIFS
https://help.smartsheet.com/function/countifs
column references are like this:
[Column Name]:[Column Name]
something like
=COUNTIFS(date-column, @cell < TODAY())
should get you started.
Craig
My formula works in my index/match when I type the employee number in, but when it is a formual, it give me #NO MATCH. See below
Hello: I am creating automations for several of my SmartSheet projects. I have successfully created an automation that alerts me when there are changes to any of 5 critical values in a row within my sheet. However, I am trying to determine how to include which of those 5 values changed in the alert email.
Hello, I'm new to Smart Sheet. I have an 'intake form' that pulls user-entered data into my Smart Sheet, and one of the fields that is entered I would like to lookup off of a Workspace I uploaded (Excel document). Are there any tips/tricks to help get this done? I linked a cell to it, but then it put a blue arrow and I…
