Sign in to join the conversation:
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
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)
More on ISDATE()
More on @cell
