Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Create an Entry on a worksheet based on the value of another worksheet
Problem Statement: We have one sheet (we will call it, Sheet A) which records the joiners/leavers for our company. In order to track whether the leaver employee returns his/her equipment, I wanted to create an entry with data from Sheet A on another sheet (Sheet based on two sets of criteria from Sheet A, Type (leaver) and Job Title. Sheet B will be used to track if/when we receive the equipment back. Is this possible? I looked at Linked Cells, but that doesn't seem to be a good fit.
Thanks for any ideas/guidance you may have SmartSheet experts!