Hi,
Due to the limited restraints on the # of rows (5,000) in Smartsheet - I need to create a formula that references multiple sheets for a match statement. See below:
=IFERROR(IF(MATCH(([Employee ID]1 + [Current Position]1 + [Training Name]1), {Completions(1) Range 1}, 0) > 0, "YES", "NO"), "NO")
I have another sheet (exactly the same format as the Completions(1) sheet) named Completions(2). I need to include that range within the above formula to search employee completion records in sheet 1 OR sheet 2.
Someone help! Much appreciated.