1

Hello,

Thanks in advance for any help provided.

I date values in column A, the day a quote is signed. I have dollar values in column B, the amount of the quote.

I want to total of the amounts in Column B that have an associated signed date. Basically, the total of value of quotes "unsigned." Pleas help, Smartsheet formulas are not as straight forward as Excel.

Comments

Hi,

Try this

Signed: 

=SUM(CHILDREN(Amount1)) - SUMIF(CHILDREN(Date1); ""; CHILDREN(Amount1))

Unsigned:

=SUMIF(CHILDREN(Date1); ""; CHILDREN(Amount1))

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done