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.
##Help ME please "i can t continue to work" SumIF##
I post a problem 2 days ago
some response but still doesn t work, new to smartsheet but my work is blocke now
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
Solution from Mike Wilday ,he s very kind but doesnt work
Try removing the brackets off of Syndic like this... brackets should only be used if the column name contains a space.
=SUMIF(Syndic1:Syndic1132], FIND("Crouzet",@cell) > 1, [Total HT]1:[Total HT]1132)
There was also a space character after the first colon. Both of those could have been the issue. Also, the Find function should have "quotes" around the text you are searching for. Let me know if it works now.
hello Mike thank you so much
but .. doesnt work
i think you understand my goal to make sum by name
THANK YOU VERY MUCH
HELP HELP HELP