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.

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions