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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!