Nov 08 2022 06:04 AM
So basically I have 2 lists
In list 1 I have a status column which has following options as
In list 2 I should be only showing the IDs of the assets which have status column as not assigned. I achieved the following with the help of calculated columns and look-up column.
In list 2 when an asset is assigned to an user the status should be changed to assigned from not assigned, when I am doing this the previous records asset ID's are all disappearing since I am using lookup based on the status column.
Kindly suggest if there is any work around for the following