Compare versions of a calculation
Calculations for sheets and forms can have multiple versions if any changes have been made to the calculation.
- Open the calculation you want to work with.
- Select the tools icon on the toolbar and selectComparefrom the menu.
- A window opens that shows how many versions there are for this calculation, showing the date when each version was created, the user who made the change, and a comment.
- Select the button next to the version you want to open and selectOK.
Any changes that were made are shown in orange. You can hover over the field to show details about the change hover over the field.
note
The previous value is shown for changes made by users, but the old values for a calculation template are not.
Show all cell changes
- Select the tools icon on the toolbar and selectList all cell changesfrom the menu.
- The List all cell changes screen opens to show a list of all changes that were made to the calculation, including template changes and changes made by users.noteThis option doesn't appear on the menu if no changes have been made.
- Select the hyperlink in the Cell Address column to open the calculation.
Exit from Compare Mode
To close the Compare window, select the
Tools
icon on the toolbar. Check the checkbox next to the Compare option on the menu.