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.

Want to return (blank cell) instead of $0.00 ???

Graeme Baker
edited 12/09/19 in Archived 2017 Posts

=SUMIFS([Value of Jobs]2, [Sales Stage]2, "WON", Result2, 1, [Sold Date]2, MONTH(@cell) = MONTH(TODAY()), [Sold Date]2, YEAR(@cell) = YEAR(TODAY()))

Comments

This discussion has been closed.