Formula help please

dave.mcpherson56751 · 08/19/18

Hi, looking for some help please.

I want to count a financial figure when the status is not received.

Columns i am using are Start up budget and Received status.

Probably really easy for someone, but am struggling with formulas as quite new to Smart Sheets.

Any help greatly appreciated.

Thanks

Dave

Andrée Starå · 08/20/18

Hi Dave,

I'm guessing that you want to sum all the rows that have the status of not received. Let me know if you were looking for something else.

=SUMIF(CHILDREN([Received status]1); "Not Received"; CHILDREN([Start up budget]1))

Please see the attached link/screenshot for more information.

Depending on your country you’ll need to exchange the semi-colon to a comma in the above formula.

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant @ Get Done

dave.mcpherson56751 · 08/28/18

Hi Andree,

thank you very much that is a great help and really appreciated.

Regards

Dave

Andrée Starå · 08/28/18

Happy to help!

Comments