I have a dropdown, single-select column that describes the type of action item listed on that row.
For example: If someone selects the Star symbol on that row, the column formula calculates that the action item is a Milestone and returns the "Milestones" option from the drop-down options.
I would like to indicate when an item is a Deliverable. This formula would need to check the row for any attachments.
This way when in Card and Calendar Views I can easily filter to see all the deliverables for the project. I know I can check the Sheet Attachments menu option, but I'd like to see how many deliverables were expected, not how many attachments (versions) we have total.
Thanks for any help!