Scenario
Create a Vendor Saved search to include a Yes/No column to show if vendor bills have attached files.
Solution
- Navigate to Lists > Search > Saved Searches > New > Transaction
- Under Criteria, enter Type: Bill
- Under Results, enter fields like Name, Document Number and Date. User may add or remove fields depending on his preference
- Under Results, add Formula (Text). Set the Formula to case when {file} is Null then 'No' Else 'Yes' End
- Set a Column Label for the formula text added
- Enter a Search Title and hit Save