Sponsor of the Day:
Jerkmate
https://help.smartsheet.com/function/index
INDEX Function | Smartsheet Learning Center
Returns a value from a range based on provided row and column indexes
function smartsheet learningindexcenter
https://help.smartsheet.com/function/vlookup
VLOOKUP Function | Smartsheet Learning Center
Looks up a value and returns a corresponding value in the same row but from a different column.
function smartsheet learningvlookupcenter
https://help.smartsheet.com/function/iferror
IFERROR Function | Smartsheet Learning Center
Returns the first value if it isn’t an error and otherwise returns the second value
function smartsheet learningcenter