modifying formulated cell in a report
In our main sheet, we have several simple Sum formulas for numbers and some for dates. We have several reports created that contain columns with the formulas. While in reports, you can change some data in each cell that will carry back to the main sheet and save. Other data is not allowed to change (even if the column is unlocked, and you are an admin). It looks like the cells that are not allowing changes are formulas. Are there rules about what cells can and can't be modified from a report? Even if the columns are unlocked?
Help Article Resources
Check out the Formula Handbook template!