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.
ISERROR or IFERROR .....Please help
Starting to expand my SUMIF formula which is great. The only issue is that it returns #INVALID DATA TYPE, when the [Sold Date] cell is left blank.
I need to add a (ERROR formula in there somewhere im guessing. Im not sure excatly how ????
=SUMIFS(IFERROR([Value of Jobs]2........ How should it look please ? Thank you
=SUMIFS([Value of Jobs]2:[Value of Jobs]50, Salesperson2:Salesperson50, "Heath Sanders", Status2:Status50, "WON", Result2:Result50, 1, [Sold Date]2:[Sold Date]50, MONTH(@cell) = MONTH(TODAY(), [Sold Date]2:[Sold Date]50, YEAR(@cell) = YEAR(TODAY())))