SecureSheets often have formulas in header rows that are summarizing data for users based on the rows returning in each end user view. If you just need to update a header row formula or formulas, you may update the header formula online through the Administration tools in SecureSheet (without exporting and importing the entire SecureSheet). You may do this online formula update before or after go-live without disrupting your end users.

NOTE:  If you need to update a formula that applies to an entire column in your data structure, you will need to export and import the entire SecureSheet. Follow the import/export instructions to apply a formula change to an entire column(s). If the SecureSheet is live, follow the Maintain a Live SecureSheet instructions to lock the SecureSheet for maintenance before importing a formula change.

Updating a Formula Online

1. Select Administration from the View drop-down. 
2. Click Formula.

3. The formula cells/columns will be visible in the SecureSheet online.
4. Make the formula update directly in the cell.
5. Click Save Changes. 
6. Click Close to leave Formula update mode. 
7. Verify the formula update in the All Data view or by impersonating an end user.