We’re rewarding the question askers & reputations are being recalculated! Read more.

in order to have Google Spreadsheets reevaluate a formula, the input arguments to the formula must get new values. In your case, the only input parameter is argument is the name of a sheet, so the formula won't be evaluated as long as the sheet name stays the same (unless you specify a refresh interval in the spreadsheet's settings). But you want to ...

Only top voted, non community-wiki answers of a minimum length are eligible