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
Options
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!!
Tags:
Comments
-
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.
