If Then type formula

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"})))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!