Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Formula Imbalance

Nicky Apap
edited 12/09/19 in Archived 2016 Posts

I know I've missed something basic here.


=SUM([Contract Amt]1:[S- AWO $]1:[CL AWO $]1)-([Material Allowance]1:[Sub Allowance]1)/[Total FB Hours])


Thanks for help!!



  • DJ Dates


    The imbalance looks like it might be the result of the final close parens.

    Another issue may be the use of ranges (colons).


    SUM([Contract Amt]1:[S- AWO $]1:[CL AWO $]1)

    should probably be

    SUM([Contract Amt]1,[S- AWO $]1,[CL AWO $]1)

    with commas instead of colons.


    -([Material Allowance]1:[Sub Allowance]1)/[Total FB Hours])

    should probably be

    -SUM([Material Allowance]1:[Sub Allowance]1)/[Total FB Hours]

    as the range may not make sense without the sum function.

This discussion has been closed.