Document Lookup Column Link
Hi, all, In SharePoint Online I have a doc library (Reference Docs) and a list (Projects). The goal is for users to choose a doc from a lookup drop-down in Projects, which, when clicked, will directly open the chosen document stored in Reference Docs. So, in Reference Docs I created a workflow that sets the value of the Title field with the Name field. In Projects I created a lookup column referencing the Title field in Reference Docs All works fine, except the link opens the document properties, not the document itself. This should be simple, but I just can figure out what is incorrect. Any help will be appreciated.
SharePoint modern list form with optional lookup column couldn't be cleared/reset
Is there a way to clear i.e. reset the value to blank for an optional lookup column. We have a list with lookup column. This column is set as optional. However, while creating new item as well as updating an existing item, if a User selects an option in Lookup column, user can't clear that option. There is no way to reset the column value back to blank. Issue only occurs in modern experience.Copy cell value from different table row
Hi, everyone. Trying to write a formula that will check a table's first column cell's value and, if it meets a criteria to do one thing and, if it does not meet a criteria, then try that first column's previous cell up (previous row above current one), if it still does not meet the criteria, then keep trying the previous cells up until it finds a cell on that first column that meets the criteria. Hopefully the image below will make the request a bit more clear: Additionally, I cannot use either macros or VBA. Thanks in advance, Edgar
Can we use VLookup to fill in fields from Scattered Data ?
Hi, I wanted to know that is it possible to use VLookup to fill in data in a certain row by matching it from different rows rather than just from a single row. In the attached image, I want to fill in the cells next to "Yellow" i.e. (H4) & "Pink" i.e. (H7) by using the same formula I used to in H2 cell which is "=VLOOKUP(G2:G7,A2:E12,2,0) ". NOTE - That I have selected the table array from "A2:E12" which covers the values of D11, E11 & D12, E12 in which the "Yellow" and "Pink" information is given. I do realise that the source has become different now, but is there a way in which I can fill in H4 & H7 through ANY FORMULA (if Vlookup can't be used) where I don't have to restructure the data in the sheet. Thank You in advance.
Sharepoint library - Lookup stopped working just on one column
I have a library with lookup columns pointing to specific lists (providers, companies, products etc.). In particular, I have two columns, "Company" and "Invoicee" pointing to the same list "companies". Everything worked perfectly for months, but suddenly since yesterday the lookup for the "Invoicee" columns stopped working. When I start typing, it seems that it starts looking for a match but it keeps looping forever. The other column "Company" that points to the same lookup list does not present the same problem and is still working properly. I thought it could be a temporary issue but today the problem is still there. Any idea on how to fix this?
