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

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!

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

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

  • Thank you!

    That is exactly what I needed!!

    Lisa

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions