Google Sheets Dashboard Tips

  • Spreadsheet performance can be impacted by volatile functions [NOW(), TODAY(), RAND(), RANDBETWEEN()] - See this LINK for details
    • Change File > Spreadsheet Settings > Calculation > Recalculation to "On Change and Every Hour" update the dashboard automatically
  • To speed up a sheet, it's a good practice to make a calculation like NOW() in it's own cell and then use the value of that cell in other calculations instead of performing the calculation in multiple formulas throughout the sheet.