![]() ![]() ![]() First one is the standard org address book you find in your personal menu under "user management". There are 2 "address books" built into Smartsheet. If your contacts are not managed centrally, or not all entries in table A have a Smartsheet account, you could still use a "personal" contact list. In your equipment table you could simply use a contacts column and in the relevant row you would start typing and select the desired username (much like here, when you use the If you require the employee ID you could use vlookup to pull it from A into B. If a Smartsheet admin in your organisation already manages Smartsheet users, then your employee names may already be in Smartsheet. Smartsheet has columns with data types and one of them is CONTACTS. So you scroll through your 2.500 list in A and link the employee's ID to the equipment entry. We have several similar scenarios where we use Airtable's "Link To" functionality to connect one table to one or more tables and where the other tables contains hundreds if not thousands of records.īut as a start, I have no idea how Airtable makes an easily accessible dropdown from 2.500 entries.Īnyway, if I understood ok, you have all your equipment in B and would like to be able to easily "assign" an item to an employee. You can use that record link to bring additional data from TableB into TableA. When a record is selected, the key reference, Provider-Shift, is what is then stored in the Provider field in TableA. When Provider (TableA) is selected, the full list of provider and shift data is shown from TableB and is easily searchable. TableB contains shift data for the past 2 months, current month and 2 future months, so upwards of 3k records and is refreshed daily. The key field in TableA, Provider, is a "Link To" (Airtable parlance) field that connects to TableB, key field Provider-Shift, which contains all provider shift data. More specifically, TableA is a small table that stores specific information about an ED provider and their shift. I'll look at SS's Cell Link option - thanks for suggesting that.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |