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.
Sumif when the criterion is a date
Options
Debbie J
✭✭✭✭✭
I am not sure how to make the criterion when the cell has a date
=SUMIF([Actual Payment Date]21:[Actual Payment Date]23, xxxxxxxx ,[Invoice Amount (tax incl.)]21:[Invoice Amount (tax incl.)]23)
Thank you
Comments
-
Hi Debbie,
You'll want to use ISDATE(@cell) as your criterion. ISDATE() is a function that checks to see if the value is a date. @cell is a unique argument to Smartsheet that is needed when you want functions that typically can only check one cell, like ISDATE(), to check multiple cells:
=SUMIF([Actual Payment Date]21:[Actual Payment Date]23, ISDATE(@cell), [Invoice Amount (tax incl.)]21:[Invoice Amount (tax incl.)]23)
This discussion has been closed.
