Only part of the formula working ? Top Half

Heath Sanders

=IF(SUMIFS([Value of Jobs]25, [Assign Too]25, "Heath Sanders", Status25, "WON", Result25, 1, [Sold Date]25, IFERROR(MONTH(@cell), "") = MONTH(TODAY()), [Sold Date]25, IFERROR(YEAR(@cell), "-") = YEAR(TODAY())) = 0, "", SUMIFS([Value of Jobs]25, [Assign Too]25, "Heath Sanders", Status25, "WON", Result25, 1, [Sold Date]25, IFERROR(MONTH(@cell), "") = MONTH(TODAY()), [Sold Date]25, IFERROR(YEAR(@cell), "-") = YEAR(TODAY())))

Shaine Greenwood

Hi Heath,

It looks as if the first half of your function (bold part) is the same as the second half. It also appears that you have a random null quote "" in the middle.

The best way to troubleshoot a function is to try breaking it apart into its core elements and find out which one doesn't work like you're expecting.

Check out the formula error messages help article if your function is presenting a specific error: https://help.smartsheet.com/articles/2476176-formula-error-messages

If you're function isn't providing an error, but also isn't do what you expect, check out our blog article on building nested IF statements: https://www.smartsheet.com/blog/support-tip-build-nested-IF

Otherwise, if you could provide more information on what you're wanting your function to do, I may be able to advise further.

Heath Sanders

Thanks Shaine...sorted now