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

Changing Status Symbol from "Hold" to "Yes" depending on dropdown menu entry
Hi all! I am looking to utilize the "Hold" and "Yes" symbols (Yellow triangle with ! and Green circle with check mark) as a "health indicator" depending on a specific value recorded in a dropdown menu column. I have a dropdown menu column whereby the you can select either "E-MAIL" or "REPORT" as the value of the "Last…
Formula for calculation
Hi Guys, I'm stuck with one critical problem, where I need one formula. I have two sheets Sheet A (contains only applied leaves, not all the dates range) Column 1 - Leave Start Date, eg 01 jan 24 Column 2 - Leave End date, eg 03 jan 24 Column 3 - Employee code, eg ABC001 Sheet B (contains entire range of dates for…
Join Collect formula that excludes the current row from the results
I'm trying to create a formula that creates a list of duplicates in my sheets, I've gotten this formula to work but it's showing the original row within the list of duplicates. I tried adding an auto number column and including a condition that the list shouldn't include the current row. However, the addition of this to…