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

Debbie J
Debbie J ✭✭✭✭✭
edited 12/09/19 in Archived 2017 Posts

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

This discussion has been closed.