I know this has been discussed here and other sites, and I understand how to get a calculated column to display info. But my situation is a little more frustrating.
I have two lists. List A is for Sessions. It has two views: Awaiting approval, and the default All Items. Everything goes into the Awaiting Approval view right away. Only after an admin assigns Date and Time does it move into All Items.
The relevant columns for List A:
-Date and Time
-Calculated column that displays the Presentation Title and Date and Time together.
List B is the form where users can sign up for available sessions. It has a lookup column that displays the calculated col from List A.
This all works fine, except the lookup col on List B displays every session. Views do not matter. Is there any way I can get a lookup that only displays 'All Items' from List A?