Insert Row ids as index configuration sheet

Creation date: 7/1/2025 10:37 AM    Updated: 7/1/2025 10:58 AM   python script smartsheet

Instruction on how to operate the configuration sheet to insert row ids as indexes:

  • Login to Smartsheet and search for the sheet called "Insert row ids as index" or click the following link (42) Insert row ids as index - Smartsheet.com 
  • For the script to successfully insert indexes, the following fields must be completed in the configuration sheet: 
  1. In a new row, enter:

    • The Sheet ID where you want to insert row IDs.

    • The Column Name where the row IDs should be written.
      (Make sure this column already exists in the target sheet before using the configuration sheet.)

  2. Once the required fields are filled in, check the Enable checkbox and save your changes (Ctrl + S). This tells the script to process that row during the next run.

  3. The Status column will be automatically updated by the script, which runs every 15 minutes. Possible status messages include:

    • ACTIVE – The row IDs have been inserted successfully.

    • INACTIVE – The row is not being processed (Enable box is unchecked).

    • INVALID INPUT – There is an issue with the provided Sheet ID and/or Column Name.

  4. If you want to stop indexing a sheet, simply uncheck the Enable box, save your changes (Ctrl + S), and the status will update to INACTIVE during the next script run.


Code:
Location: P:\Alex_Argumedo\scripts\Santiago Marin\get_row_ids.py
Python: get_row_ids.py
Frequency: 15 min
Automated Execution: Windows Task Scheduler

Attached: current version of the script running in production