Override Column Formula for Particular Cells
It would be great if we could edit single cells within a column that has a column formula in place without having to convert it back to a Cell Formula! That way if we have accurate data for one cell, we can change it and still keep the formula for the rest of the column!
Comments
-
To add an additional aspect of this, I often find that I want different formulas for nested rows. For example, the child rows have a column that calculates some values, and the parent column should be the sum of its' children. This can be done by using supporting hidden columns and/or complex nested '=if()' statements in the column formula, but it could be much easier.
-
@LukeSmartsheet104, here's a quick workaround suggestion. Create an override column (call it "Override"). Assuming that "<Your Formula>" is your original formula, update it as follows:
=IF(Override@row<>"", Override@row,<Your Formula>)
This says, IF you enter any information in the Override cell, your column will display that cell's information. OTHERWISE, it will use the original formula.
Hope this helps!
-
Thanks for this suggestion, could you help me further, the formula in the column i want to overide is below:
=IF(Rate@row = "Film Very Large Half Day R20 000"; 20000; IF(Rate@row = "Film Very Large Full Day R25 000"; 25000; IF(Rate@row = "Film Very Large 24 HR R45 000"; 45000; IF(Rate@row = "Film Large Half Day R15 000"; 15000; IF(Rate@row = "Film Large Full Day R18 750"; 18750; IF(Rate@row = "Film Large 24 HR R29 000"; 29000; IF(Rate@row = "Film Small Half Day R10 000"; 10000; IF(Rate@row = "Film Small Full Day R12 500"; 12500; IF(Rate@row = "Film Small 24 HR R9 375"; 9375; IF(Rate@row = "Photographic Small (SL) Half Day R6 000"; 6000; IF(Rate@row = "Photographic Small (SL) Full Day R9 000"; 9000; IF(Rate@row = "Photographic Small (SL) 24 HR R13 500"; 13500; IF(Rate@row = "Photographic Large (SL) Half Day R9 000"; 9000; IF(Rate@row = "Photographic Large (SL) Full Day R13 500"; 13500; IF(Rate@row = "Photographic Large (SL) 24 HR R20 250"; 20250; IF(Rate@row = "Photographic Small (ML) Half Day R12 000"; 12000; IF(Rate@row = "Photographic Small (ML) Full Day R18 000"; 18000; IF(Rate@row = "Photographic Small (ML) 24 HR R27 500"; 27500; IF(Rate@row = "Photographic Large (ML) Half DayR 18 000"; 18000; IF(Rate@row = "Photographic Large (ML) Full Day R27 500"; 27500; IF(Rate@row = "Photographic Large (ML) 24 HR R40 500"; 40500))))))))))))))))))))) * [Shoot Days]@row
I want to create an overide if I need to manually put in a value that does not correspond to the above formula for a particular cell as sometimes we negotiate a rate and its not what is in the formula. How do I do this with your suggest of overide column? Or Is there a new work around?
Regards
