Is there a formula that can check if a row has an attachment?

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!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!