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
-
Eric Law ✭✭✭✭✭@sheetsmartsarahYou can create an automation that triggers when an attachment is added, you checkbox/star/whatever a column that is named Has Attachment.
Answers
-
Eric Law ✭✭✭✭✭
@sheetsmartsarahYou can create an automation that triggers when an attachment is added, you checkbox/star/whatever a column that is named Has Attachment.
-
Thanks@Eric Law! I didn't think about an automation.
I've created a template with attachments pre-loaded. I guess I can preset the rows to "Deliverable" and then the automation can take care of any future attachments.
-
Looks like I ran into an issue with having both a column formula and an automation. The automation says it can't be run because the column (with a formula) is not writable. I'll play around with using only a workflow vs a column formula.
-
Eric Law ✭✭✭✭✭
@sheetsmartsarahglad to assist! Sometimes we are too close to the project. Also, yes you can't have an automation with a formula as you would override the formula with the automations. Reach out if you need any other assistance!
-
thanks@Eric Law:) I think the automation alone works out for what we need. Thanks for helping me simplify it!
Help Article Resources
Categories
I believe this requires you to change the column type to a contact-like one. <\/p>
Then you should be able to select it in this dropdown. <\/p>
Ryan<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":110640,"type":"question","name":"Sum Formula containing keywords?","excerpt":"I'm trying to keep a running sum of the amount of liquid we are holding for our business's transfer log and I am not even sure where to begin! We have to log transfers (IN) and (OUT) and I would like to write a formula to keep up with this if possible. (Adding the amount in rows with IN and subtracting the amount in rows…","snippet":"I'm trying to keep a running sum of the amount of liquid we are holding for our business's transfer log and I am not even sure where to begin! We have to log transfers (IN) and…","categoryID":322,"dateInserted":"2023-09-22T01:44:27+00:00","dateUpdated":null,"dateLastComment":"2023-09-22T12:05:15+00:00","insertUserID":151299,"insertUser":{"userID":151299,"name":"lcain","url":"https:\/\/community.smartsheet.com\/profile\/lcain","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-22T12:38:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":15741,"lastUser":{"userID":15741,"name":"ker9","url":"https:\/\/community.smartsheet.com\/profile\/ker9","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-24T18:20:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":35,"score":null,"hot":3390731982,"url":"https:\/\/community.smartsheet.com\/discussion\/110640\/sum-formula-containing-keywords","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/110640\/sum-formula-containing-keywords","format":"Rich","lastPost":{"discussionID":110640,"commentID":396586,"name":"Re: Sum Formula containing keywords?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/396586#Comment_396586","dateInserted":"2023-09-22T12:05:15+00:00","insertUserID":15741,"insertUser":{"userID":15741,"name":"ker9","url":"https:\/\/community.smartsheet.com\/profile\/ker9","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-09-24T18:20:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Get Help","url":"https:\/\/community.smartsheet.com\/categories\/get-help"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/I6ZQZFEI6SV8\/screenshot.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-09-22T12:09:07+00:00","dateAnswered":"2023-09-22T12:05:15+00:00","acceptedAnswers":[{"commentID":396586,"body":"
