Hi Community,
I have a worksheet with a column (let's call it "FPD Factor") for calculating how many files can be scanned per day by a process. I would like for every new record created to have that column auto-populated with "70,000", but want it to be overwrite-able by someone. I plan to use the FPD Factor value in a calculation that forecasts/estimates when a certain number of files to be scanned will finish. I know how to do all of the formula's, but am struggling with how to set up the column so that any new records have a value of 70,000.
I'm using forms for some (but not all) entries into this worksheet, so that won't solve my problem.
Suggestions? It's worth a coffee at Engage if you'll be there.
Thanks.