Advanced VLOOKUP

Sak2195
Sak2195 ✭
edited 11/06/24 in Formulas and Functions

I have a sheet 1 having column object name as ZCONXXX (where XXX are numbers) and another sheet with task name having tasks for execution like “Review and upload ZCONXXX” and I need to update duration in sheet 2 matching object name column in sheet 1 to task name column in sheet 2. Help please

· Share on FacebookShare on Twitter

Answers

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!