If Then type formula

Frank Allen B

I am trying to write the formula to pull info submitted to a grid about lock status. The form allows one to submit a locked or removed lock status. I am trying to pull from the grid the form feeds to create an automated current status (for a dashboard) on the lock per the grid.

The created date would be the trigger on what status is most current for any particular lock. But cant seems to grasp the formulas. Any help is appreciated.

=IF({LOTO Master Data FBP Machines} = "801", AND({LOTO Master Data Lock Status} = "Applied", AND({LOTO Master Data Created Date > {LOTO Master Data Lock Status} = "Removed", {LOTO Master Data Created Date}, "Locked"})))

Paul Newcome

Are you able to provide screenshots for context?

Frank Allen B

This is the grid the form feeds into. I want to write a formula on a separate grid to pull from this log and update the most current lock status as submitted. This grid will remain as the overall lock log, but the formula will help to create a dashboard to quickly see what locks are on or not.

Paul Newcome

I would suggest having the forms populate the top of the sheet. Then you can use a basic INDEX/MATCH.

=INDEX({Source Sheet Status Column}, MATCH([Lock Number]@row, {Source Sheet Lock Number Column}, 0))