ISO Correct Formula

Options

Hi - Looking to total $ values in col. E. However, if a date is entered into col. D the value should be excluded from total.

Any ideas & thanks in advance!

Answers

  • Vojtech Gajdos
    Options

    Hi @Eve_Cherry

    With as little info as you mentioned in your question - the following might be the answer:

    =SUMIFS([ColE]:[ColE], [ColD]:[ColD], @cell <> "")

    (Assuming ColD is a Date column so it either contains some date or is blank - which the above formula is checking)

    Hope this helps

    Vojtech

  • Eve_Cherry
    Eve_Cherry ✭✭
    edited 09/10/22
    Options

    Hello @Vojtech Gajdos & thanks for your response.

    Your assumption is correct -- Col D is a date column

    The formula should not consider blanks because blanks are expected/acceptable. It should only check for dates in Col D.

    As such, how should the formula be revised?

  • Vojtech Gajdos
    Options

    Hi Eve, so - the value in ColE should be included when the date IS blank? In which case the formula should simply change to:

    =SUMIFS([ColE]:[ColE], [ColD]:[ColD], @cell = "")

    Not sure though if I fully understand what you are trying to achieve 😀 (in your original post you mentioned that "if a date is entered into col. D the value should be excluded from total" but from your recent one it seems like the value should be included when there is a date entered. Anyway, use one or the other version of the formula.

    Regards

    Vojtech

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!