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.
Pull Down Menu Options from Common Source/Sheet
I am using Smartsheets to track time, and have run into an issue that I have to believe there is a workaround for. We need our associates to track their time with specific job and client IDs. This can be done by making the time tracking entries show as a pull down menu of codes. But, when we get new jobs or clients, there doesn't seem to be a way to link this list of jobs to the job ID column in everyones sheet. Therefore, it is easy to enter job IDs incorrectly, and there is no verification that entered data is valid. Is there a way to link a pull down menu to a master sheet of job IDs and clients? That way it could be managed in one place, and ripple to everyone's time sheet.