Why all cells in a column are updating if one cell in the sheet as been change
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!
Answers
-
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.
Hope that helps!
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives