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!
Help Article Resources
Check out the Formula Handbook template!