RCFX Setup & Audits Sheet – Manual Update

Posted by: Paul Pampolino Date Posted: January 26, 2026
Back to Case Studies

Issue

The RCFX Setup & Audits Sheet hasn’t been updated yet. This means options like the new Architects might not be available, along with some other information.

Solution

Manually update the sheet by navigating to Extensions > Apps Script. Then, in Main Function.gs, select the onOpen() function and comment out the “//” at the beginning of the two functions (ss).

  1. mtechsheet.insertSpreadsheetName(“B1”)
  2. mtechsheet.setUserFirstName();

Click Run and grant the necessary permissions if prompted. The Execution Log will display “Execution Completed” once it finishes successfully. Once confirmed, remove the “//” comments from the two functions and click Save. Then, return to the sheet, which should now be updated.

 

Achievement

The MarTech team can smoothly update the sheet whenever errors come up, without needing to contact the developer of the RCFX Setup & Audits Sheet.

Snippet/Screenshot/Link