Formula

padw
padw ✭✭
edited 12/09/19 in Formulas and Functions

Hi,

Hopefully I'll explain my predicament correctly!

Ive set up a sheet for the commercial department to track orders. I need a formula to track the value of orders quoted in a certain month.

The column I need the date range to come from is called Date Out

The column I need the descriptor to come from is called Status, and the descriptor in this instance is named - Quote Sent Out

The column to calculate from is called GRP.

 

Hope someone can help?!?

 

Thanks

 

 

 

Comments

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    edited 06/07/18

    The only way I have been able to get it to work is to add a support column which you can shrink the width to the minimum, use white fill, and use white text to hide it a little bit. You can also put it anywhere within the sheet. I usually stack my support columns on the for right, do all of the above, and lock them.

    In your Support Column enter:

    =MONTH([Date Out]@row)

    In your totals column enter the following:

    =SUMIFS(Value:Value, Status:Status, "Quote Sent Out", Support:Support, #)

    (Replace the "#" with whatever month number you are calculating for)

    I have tried about a million different ways to get it to just look at the month in COUNTIF and SUMIF functions to avoid adding a column, but I either get an error, "0", or "1".

    Untitled.png

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

  • padw
    padw ✭✭

    Wow! Thank you for your help. Enjoy your weekend!!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!