Prompt User to complete field in a closed sheet.
I have three separated sheets, one is an entry sheet, open requests sheet, and closed requests sheet. I have an automation setup to take information from the entry sheet to the open requests sheet as well as the closed requests sheet, if all the conditions meet. In the closed request sheet if I have a field that is not completed, when a user is about to enter a new entry based on which department is selected and if that department match with the department in the closed requests sheet. I want to prompt or send the user to complete the missing field in the closed request s sheet as the user entering the data in the entry sheet. Is that possible to do in smartsheet? If you please help me understand how to do that. Thank you!