Cross reference cell value against the column name?

Is there a formula or function that will lookup a value in another column (same row) and check against the column name?

I have a Cell with a start date from a new employee. I then calculate a date of when that employee will be fully trained (Ramped). I need to then indicate that this new employee is capable of contributing as a Ramped Resource by setting the cell under the column with the corresponding date in the "Full Ramp....." date?

CleanShot 2022-09-23 at 14.42.01.png


Answers

  • Darren Mullen
    Darren Mullen Community Champion

    @Eyemalive Unfortunately no. You would have to write a unique formula for each column to check if it matches the "FULL RAMP..." date.

    Alternatively, you could put the dates in the first row in the sheet, lock it so most users can't change it, and accomplish what you want to do, but that may or may not work for your case since the first row would be analogous to a "header row" that you may want to filter out for display purposes

    Darren Mullen - Looking to take your Smartsheet knowledge to the next level and become an expert? Join the Smartsheet Guru Elite

    Get my 7 Smartsheet tips here

    Author of: Smartsheet Architecture Solutions

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!