Show status based on user answers to most recent inspection

[Chris_Bean1]

Morning folks

I am trying to show the status of an item listed in one tab based on entries recorded by users in another tab. I have a list of skips used for transport in a master data tab, and skip inspections completed by users in another tab. The skip inspections are yes/no questions, and a series of 'TRUE' for those questions mean the skip is good to go. 

I would like the status of the skip in the master data tab to be determined by the most recent skip inspection. If there is a 'FALSE' in any of the user answers, it should show 'defected', if it's all 'TRUE' then 'ok'. 

I have this in the App Formula of the column editor:

if(max((Skip inspections[date]).[skip number]),

(Skip inspections[Door hinges intact?]=true,

Skip inspections[Bottom bar moving easily and closing door correctly?]=true,

Skip inspections[Guide rails free of damage?]=true,

Skip inspections[Are the welding joints intact, showing no cracks?],

Skip inspections[Is the lifting bar secure, showing no cracks?]=true,

Skip inspections[Are the walls in good repair?]=true,

Skip inspections[Are all rear door twist locks present and securing to the door correctly?]=true,

Skip inspections[Is the sheet centre pole intact and straight?]=true,

Skip inspections[Sheeting system intact, no holes?],=true,

Skip inspections[Are the straps that secure the sheet present and correct?]=true,

Skip inspections[Is the ratchet securing device present and working well?]=true),

"ok", "defected")

As ever, any help appreciated

Cheers

Chris