Why all cells in a column are updating if one cell in the sheet as been change

Alexandre Couillard

I have a column that I use to do a summary multiples fields in a row to have a better understanding of what this row contains. Here is the formula :

=IF(Type@row = "Approche", [ID Projet]@row, "P-" + [# Projet]@row) + " (" + [État du projet]@row + ")" + CHAR(10) + "―Client: " + Client@row + CHAR(10) + "―Nom Projet: " + [Nom du projet]@row + CHAR(10) + "―Chargé de projet SE: " + [Chargé de Projet]@row + CHAR(10) + "―Dates: Du " + [Date (Début)]@row + " @ " + [Date (Livraison)]@row + CHAR(10) + "―Catégorie: " + Catégorie@row + IF(ISBLANK([Sous-Catégorie]@row), "", " - " + [Sous-Catégorie]@row) + IF(OR([État du projet]@row = "Perdu", [État du projet]@row = "Annulé"), CHAR(10) + "―Raison de perte: " + [Raison de la perte]@row, "") + CHAR(10) + "Soumission/Échéancier: " + [Vers Soumission]@row

My problem is that every time a single cell in all the sheet is change, this column update all the rows for no reason. Did someone else had this problem in the past. You can see in yellow all the cells that have been updated.

Thank you!

Ayelet Weiner

It looks like you have the formula setup as a column formula. That's indicated by the "fx" at the top of the column. You can right-click any cell in the column and select Edit Column Formula or Convert to Cell Formula to change or remove the column formula.

https://www.smartsheet.com/content-center/product-news/release-notes/column-formulas?iOS=

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas?iOS=&_ga=2.194211245.1029654355.1611591356-1015414472.1605106480

Hope that helps!

Alexandre Couillard

Yeah, I know it is a column formulas and I want it that way! I have a lot of column formulas in this sheet, but none of them are doing this "All update at the same time" behavour when a cell is updated in the sheet.

I want to understand why this column is doing this and not all the others.