Anchor vLookup formula in a cell

bmcmahan25381

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!

Brad

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.