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.
Problem with SumIF
Hello @Craig and other Helpers
i experiment the same issue than other
sorry for my english but i m french
i copy your formula below and try to adapt with "laserjet" type
i want to make a sum if a name appear in the row i write it but doesn t work
=SUMIF( [Syndic]1: [Syndic]1132]; FIND("Crouzet"; @cell) > 1; [Total HT]1:[Total HT]1132)
in order to find "Crouzet" wich is a part of name ex "Crouzet Breil"
I m new to Smartsheet et don t understand why
Appriciate help of community
after i will reuse the same formula to make some with different type of name exemple "foncia", "taboni" but can appeat in row "cabinet Foncia" , or "cabinet Taboni"
return error is #unparseable