Find & Replace in Riskheet

In any large-scale project, staying consistent across thousands of entries can quickly become daunting. Risksheet’s Find & Replace feature helps streamline this challenge by letting users instantly update recurring values across the entire sheet. Whether you’re correcting a repeated typo, updating team names, or applying a change in risk classification, this function ensures accuracy without the manual effort.

This feature has been supported since version 25.10.0.

TABLE OF CONTENTS

• How to open the Find & Replace menu
• How to use Find & Replace
  • Additional Options

How to open the Find & Replace menu

1. Directly on the toolbar - three dots next to the Search bar

2. Menu > Edit > Find & Replace

How to use Find & Replace

At the moment, the Find & Replace tool works only for editable single-line and multi-line text columns

1. Start by filling the Find field
2. Choose the word you want to replace it with
3. Choose where on the Sheet the pattern should be replaced (You may choose from sheet, column, or selection)
4. Replace a single result or Replace all

Additional Options

Regex - Use regular expressions for advanced pattern matching

• This enables powerful and flexible search patterns. Instead of typing exact text, you can describe a pattern using special symbols
• Example: Find > ABC-\d{4}; Finds all risk IDs like ABC-1234, ABC-8452, etc.

Case Sensitive - Match text with exact letter casing

• Only matches text that exactly matches the capitalization you typed
• Example: Find > "risk" won’t match Risk or RISK

Whole word - Match only complete words

• This ensures the tool matches a full word, not partial matches inside other words.
• Search for "mode"
  • Without Whole word: matches mode, demode, modeled
  • With Whole word: only matches exact "mode"

Overlap - Allow matches that overlap each other

• This tells the system not to skip over overlapping matches.
• Example
  • Text: ADADADAD
  • Find: ADAD
  • Replace with: 1
    Without overlap: finds 2 matches [ADAD] [ADAD] -> 11
    With overlap: finds 3 matches [ADAD] [ADAD] -> 111 (since there's an additional ADAD pattern in the middle)

Wrap search - Allow next/previous navigation to wrap around

• Enabled by default
• Example
  • Wrap Search ON: 4 results > You will be able to go from 4 of 4 to 1 of 4 and vice versa
  • Wrap Search OFF: 4 results > You can only navigate from 1of 4 until 4 of 4

Filter matching rows - Display only rows containing matches

• Enabled by default
• When this is enabled, only rows where a match is found will remain visible in the view. It’s a temporary filter that hides irrelevant data
• Uncheck or exit the menu to see all rows again

For any assistance, please don’t hesitate to reach out by submitting a ticket here.