sumif - total costs open damages

Hi,

I wonder what is wrong with this formula ("unparseable")

=SUMIF([Kostenschätzung / Zahlbetrag]:[Kostenschätzung / Zahlbetrag]; COLLECT(Bearbeitungsstatus:Bearbeitungsstatus); <>"abgeschlossen"))

I guess you will find my fault... ;-)

Best Answer

Answers

  • very helpful. It works. Thank you ;-))

  • Stefan
    Stefan ✭✭✭✭✭✭

    Happy to help

    Greetings

    Stefan

    Smartsheet Consulting, Solution Building, Training and Support.

    Projects for Processes and for People.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!