Our Google Sheets integration is designed for displaying your data and, for this reason, doesn’t support any sort of modification or calculation of it. This means any changes to your spreadsheet data must be done outside of Geckoboard first.
That said, we've prepared a spreadsheet with ready-made calculations for you to copy and make your own. To find out how to use it and make it your own, see our article on calculating spreadsheet data for Geckoboard.