Out of Service Formula
I'm attempting to create a formula showing the OOS status of the most recent submission for each asset based on the Asset ID in form submissions. For example, below Asset ID FD-001201 would be considered out of service, however, I'm not sure how to account for it being the most recent submission if there had been a previous entry where the OOS Tag had been removed.
My assumption is the the formula would look something like IF(Countif(Asset ID = FD-001201), "No", "Yes", if(and(countif(asset ID = FD-00120), OOS Tag Removal Date "Blank", "Yes", "No")) but this wouldn't account for only the most recent submissions.
If someone knows how to account for ONLY most recent submission for a given Asset ID or another way to write the formula, it would be greatly appreciated.