New answers tagged

0

Unfortunately, Calculated columns cannot directly perform lookups in other tables, and if you added a relational Lookup column, you cannot reference Lookup columns from with a Calculated column formula. However, creating a workflow (or a Power Automate Flow, depending on which version of SharePoint you are using) would be trivial. Trigger your workflow on ...


0

In order to create a relationship between the two lists, you would need to add a Lookup column from one to the other. Which list you choose to put the lookup column on could be a matter of debate, however, I would suggest adding a Lookup column on the "Borrowed Equipment" list pointing to "HR". In general, when choosing the direction of the lookup, if ...


0

For this requirement, you need to create a new column of number type to hold the currency value in number format, this column you can refer in your custom forms. To copy the currency value to number column, you need to create a SPD workflow in your list, where you will have only one action step, Set Field in Current Item, in which set the currency field ...


0

You have to create the Lookup columns in the HR List, Select source list as Borrowed Equipment and select the fields that you want to show in HR List


Top 50 recent answers are included