Formula help please

dave.mcpherson56751dave.mcpherson56751 ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions
08/19/18 Edited 12/09/19

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

Tags:

Comments

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    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.

    https://cl.ly/223f0t0T2y1Y

    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

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

  • dave.mcpherson56751dave.mcpherson56751 ✭✭✭✭✭

    Hi Andree,

     

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

    Regards

    Dave

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Happy to help!

    SMARTSHEET PARTNER & CONSULTANT / EXPERT

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.