Anchor vLookup formula in a cell

Is there a way to create an anchor for vlookup or index/match formulas in Smartsheet? I have created an order form with a vlookup column in a sheet to pull in pricing. My concern is that when the resource sheet price changes then the price changes in my order form. I would like for the price to stay the same when the order is created. Currently is changes when the resource prices changes. Is there a way to lock or freeze this price in the order form cell?

Thanks in advance for any help or information!



  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭

    You would need to include a date type column in your price list sheet and log the date of each submission. When a price changes, you would insert a new row on your price sheet instead of changing the existing entry.

    From there you can include a date comparison to determine which price to pull from the table.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!