Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
COUNTIF problems with data types
( I have looked extensively to see what issue I'm having but cannot find an adequate answer )
=COUNTIF(StartDate:StartDate, MONTH(@cell) = 2)
Task: Just count the rows where a Date Field is FEB ( we'll use StartDate as the field and it is a DATE field ) ----- The result I get is #INVALID DATA TYPE
Why is SS indicating a problem here?