Refresh a report using a sheets function

Colin Dellow

Colin Dellow

To trigger a report to refresh, use the SW_REFRESH(<address of top-left cell of report>) function. This function is similar to clicking on the Refresh button of a report to refresh it.
 
notion image
 
Examples:
  • Refresh a report in cell A1: SW_REFRESH("A1")
  • Use the CELL function to convert a cell reference into an address: SW_REFRESH(CELL("address", A1))
  • Refresh a report in cell A1 in sheet MySheet: SW_REFRESH(CELL("address", MySheet!A1))
  • Refresh a report when the checkbox in cell A9 is checked: IF(A9, SW_REFRESH(CELL("address", A1)))