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

Graeme Baker ✭✭

02/15/17 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()))

0 ·

Comments

Benjamin Walker Employee

02/15/17

You could add an if statement that returns "", which is an empty string.

0 · Share on Facebook Share on Twitter
Shaine Greenwood Employee

02/16/17

Hi Graeme,

Looks like you're working on the same sheet as Heath!

I replied with a formula in that thread: https://community.smartsheet.com/discussion/how-do-i-return

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Data Shuttle filter for dates after a certain date?
I'm trying to pull data from an Excel report into Smartsheet. I cannot change the parameters of the Excel report, but I only need rows that have been updated after a specific date to merge into Smartsheet. I tried adding a filter that is greater than the date, which works in reports, but Data Shuttle is still pulling in…
No Dropdown for the 'Enter Value' cell in my report filter/s listing "Current User"
I'm trying to create a report using the 'Current User' filter feature. However, when I attempt to setup the filter in the report that I just created, there's No Dropdown for the 'Enter Value' cell. I just get a text box. Also, the 'Enter Value' text box has a red outline prior to attempting to type something. Nothing…
Forms - link a document
Hello, how do I link (add) a report to a form? When the green "Account List" is clicked i want it to open a report?