Sign in to submit new ideas and vote
Get Started

Enhanced Formula Editing - Mass Changes to Formulas on Sheet

Quite often, I am entering the same formula, with the only differentiation being an identifier for a unit or job role. This becomes tedious and is a very manual process. In Excel, the ability to find and replace eliminates this repetitive manual changing to a few keystrokes. Looking for the same functionality within Smartsheet.

3
3 votes

Idea Submitted · Last Updated

Comments

  • Erin Horiuchi Green
    Erin Horiuchi Green ✭✭✭✭✭

    @DataDaveRN Have you tried creating a cross-reference Smartsheet to help logically identify the Unit or Job Role?

    Then you can implement into your formula a VLOOKUP to the cross-reference sheet.

    Erin Horiuchi Green, MBA, LSSYB, PSMI
    Process Manager
    Syneos Health

    Please kindly like ❤️, upvote ⬆️ and/or mark ✅ any of my contributions that have provided value.

    Core App and Project Managment Certified 🚀