So I have items in the list which is linked to the documents in the document library using lookup columns where users can see how many documents have been linked to the selected list item.
The scenario is below.
User changes the status of the choice column from "todo" into "completed" in the list and they want it to be tagged or somewhat linked to the document or documents to be uploaded once they have completed in the list for that column. I couldn't find any information or tips to implement the scenario I have mentioned above. I was thinking of creating lookup columns to link choice columns from the list but unfortunately, lookup columns do not support choice columns. Also, I have already implemented validation rules to the choice columns so because of the nature of the project I can not use a lookup column instead of a choice column.
I would appreciate any suggestions or alternatives to achieve this.