Skip to content
  • Try Smartsheet

    • Smartsheet Product Feedback & Ideas

    Smartsheet Product Feedback & Ideas

    Help shape the future of Smartsheet! Share your feature wishlist and improvement requests here.

    Sign in to submit new ideas and vote
    Get Started

    Override Column Formula for Particular Cells

    ✭✭
    in Smartsheet Product Feedback & Ideas

    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!

    Tags:
    Share on FacebookShare on Twitter
    4
    Up
    4 votes

    Idea Submitted · Last Updated

    Sign in
    Try Smartsheet

    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.

      · Share on FacebookShare on Twitter
    • Community Champion

      @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!

      · Share on FacebookShare on Twitter
    • ✭✭

      Hi @LukeSmartsheet104

      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

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Quick Links

    Categories

    Trending Ideas