I have List A which has all information.
List B has Col 1 that looks up one of the List A's columns. Col 2 is a Calculated column that want to use Col 1 but SharePoint is not able to see Col 1 because it's a Lookup column?
In the Calculated column; 1) Are we able to use a column from another list? 2) Is there anyway we could use a Lookup column?
Thank you guys!