Formula SumiF

Adilson Mota

Hello.
When I use the sumif between different Smartsheet and de column is formula the result not calculated but when put the value the formula sumif is ok.

like attached.

WHAT IS THE BEST FORMULA ABOUT THIS CASE?

SumIf between two Smartsheet's, but both columns to search use formulas don't use absolute value

SUMIF beteew formulas.xlsx

between formula?

Paul Newcome

The formulas outputting the "numbers" are actually outputting text strings that just look like numbers. Try wrapping each of them in a VALUE function.

=VALUE([Column Name]@row + "." + [Other Column]@row)

Paul Newcome

The formulas outputting the "numbers" are actually outputting text strings that just look like numbers. Try wrapping each of them in a VALUE function.

=VALUE([Column Name]@row + "." + [Other Column]@row)

Adilson Mota

Thanks very much.

Paul Newcome

Happy to help. 👍️