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

Modified by automation instead of name
Good afternoon, If I send a request for info and there is a check box, if they click on the box via the request in the email, it says it's modified by: automation@smartsheet.com instead of Bob. Is there a way to get the person who clicked on the boxes name on there instead of automation? Thanks
Countifs formula not returning a value.
Challenge: Countifs formula is not returning a value from a cross sheet. Any help would be so greatly appreciated. Summary: I am trying to pull in counts for a specific month and status for an application. The formula doesn't state any errors but it doesn't return the values. Formula: =COUNTIFS($Name18, {Status}, [JAN…
Help with a Sheet Summary Formula Error
I have a simple sheet summary formula that keeps returning "Invalid Operation". I am wanting to count the number of instances where the Potential Loss column is over $500. I've tried every variation of "500" I can think of (500.00, $500, "500.00"), but it's still returning an error. Any thoughts on what's wrong with my…