Welcome!

This Post is Archived and Read-Only

The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.

Browse Active Topics

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())))

Comments

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.