Skip to content
  • Try Smartsheet

    • Formulas and Functions

    Formulas and Functions

    Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

    Conditional Formatting on Multiple Sheets

    ✭
    in Formulas and Functions

    Hello,

    I am a Trainer for Amazon. It is my job to track any training that is performed within the building. I have my other trainers scanning Associate badge numbers into a sheet - one number per line. What I need is to have those numbers, after all are entered and saved, to match up with the corresponding badge number in my Associate Information Sheet.
    For example: Jane just trained 10 Associates and scanned their badge numbers into rows 1-10 on the training tracker sheet. I would like to see if there is a way to have those 10 numbers entered fill the matching badge number cell within the Associate Information Sheet as a visual that they have been trained.

    Is this possible to do? Thank you in advance for any assistance!

    · Share on FacebookShare on Twitter

    Best Answer

    • ✭✭✭✭✭
      Answer ✓

      Hello @Lisa McMunn

      Try this:

      1. Create a helper column (for example checkbox "Training Done" column) on your Associate Information Sheet
      2. Add this formula:
        1. =IF(HAS({Badge # Column in Training Tracker Sheet},[Badge #]@row),1,0)

      This will check a row where the Badge # in the Associate Information sheet is found in the Training Tracker. Just make sure to change the correct references in the formula.

      Melissa Yamada
      melissa@insightfulsheets.com
      Data made simple, spreadsheets reimagined

      · Share on FacebookShare on Twitter

    Answers

    • ✭✭✭✭✭
      Answer ✓

      Hello @Lisa McMunn

      Try this:

      1. Create a helper column (for example checkbox "Training Done" column) on your Associate Information Sheet
      2. Add this formula:
        1. =IF(HAS({Badge # Column in Training Tracker Sheet},[Badge #]@row),1,0)

      This will check a row where the Badge # in the Associate Information sheet is found in the Training Tracker. Just make sure to change the correct references in the formula.

      Melissa Yamada
      melissa@insightfulsheets.com
      Data made simple, spreadsheets reimagined

      · Share on FacebookShare on Twitter
    • ✭

      Thank you!

      That is exactly what I needed!!

      Lisa

      · Share on FacebookShare on Twitter

    Sign in
    Try Smartsheet

    Help Article Resources

    Create and edit formulas in Smartsheet

    Formula combinations for cross sheet references

    Smartsheet functions list

    Quick Links

    Categories

    Want to practice working with formulas directly in Smartsheet?

    Check out the Formula Handbook template!

    Trending in Formulas and Functions