I want to lock cell and don’t allow anyone to change it. For example, when we begin a new month, I want the program will automate lock the planning data in the past and it can’t be changed. How I can do that?
Hi – Sorry this was not answered sooner. However, there is not auto-locking feature in Quantrix. However, you can certainly set up a time control in the model that detects if a month is in the ‘actual’ period… then use the actual numbers. Otherwise, refer to some type of “forecast” item to get that forecast or planning number.