This is an advanced feature most users will not need. Normally the best way to refresh a report in SyncWith is either on a schedule, or by clicking the Refresh button in either the report status row or in our product itself.
However, if you're looking to do something advanced or custom then there is another way to trigger a report refresh using a function in Google Sheets, but this is rarely needed.
To trigger a report to refresh using a function you can 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.
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)))