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 select
Compare
from 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 select
OK.
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 select
List all cell changes
from 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.
note
This 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.