Move conditional format rule - Automate.ax

googleSheets.moveConditionalFormatRule() changes a conditional-format rule’s priority within one sheet.

Example

import { automation, onDashboardRun } from "automate.ax"
import { googleSheets } from "automate.ax/google-sheets"

export default automation("Lower a formatting rule's priority", () => {
  onDashboardRun({ title: "Lower a formatting rule's priority" })

  googleSheets.moveConditionalFormatRule({
    spreadsheet: "spreadsheet-id",
    sheet: "Orders",
    fromIndex: 0,
    toIndex: 2,
  })
})

Inputs

Provide spreadsheet, sheet, current zero-based fromIndex, and new zero-based toIndex. Indexes are per sheet and are positions, not stable IDs. Moving a rule changes the indexes in the affected priority list. Second argument { account } selects the Google Account. All action inputs accept compatible signals.

Output

Returns the moved rule as { index, ranges, rule }, where index is toIndex.