The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
On occasion, our functional teams need to edit/add/subtract information from documents attached to specific project lines. The version history information helps us untangle the “conflicted copy” mess we get into sometimes and it seems that Smartsheet isn’t in business to become a document management system. Minimally, it would be nice to know at the time you download an attachment, when the last number of downloads happened and who they were downloaded to. At least that would give our teams a name to contact to coordinate the updates. We have a decent document revision nomenclature policy, but that still doesn’t help when two people are working on the same revision at the same time without knowing it. Any thoughts?
Justin, are you and your team Google users? Google Docs would be a great way to solve your issue. Rather than using MS Word, add all your documents to Google Docs then attach them to your sheets. With Google Docs, your users can click on the attachment in Smartsheet and will be brought to the Google Doc, where multiple users can work on it in real time with each other. They will never have to worry about what version they are on or reattaching the file back to Smartsheet. Google Docs does require an internet connection but you could always download the Doc, make your changes, then copy and paste the changes into Google Docs if you need to work on it where you do not have internet.
Ok, how about using a helper column with a 0 or 1 being input by your automation, and then use this as the trigger. So set the default on the column to 0, and if an attachment is there, leave it at 0. Then if an attachment is not there workflow will set it to 1, and that would trigger the automated workflow to run.<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","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":[{"tagID":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":108318,"type":"question","name":"Count to show the High Priority Items","excerpt":"I would like to add a formula that counts the number of 1 - High, 2 - Med, 3 - Low in each row.","snippet":"I would like to add a formula that counts the number of 1 - High, 2 - Med, 3 - Low in each row.","categoryID":322,"dateInserted":"2023-07-31T18:51:49+00:00","dateUpdated":null,"dateLastComment":"2023-07-31T19:48:33+00:00","insertUserID":121230,"insertUser":{"userID":121230,"name":"Kris Peeters","url":"https:\/\/community.smartsheet.com\/profile\/Kris%20Peeters","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zzjX8w2dwDY!5FVWucGjaaQ!-sgJ3Uz0EeO","dateLastActive":"2023-07-31T19:46:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":121230,"lastUser":{"userID":121230,"name":"Kris Peeters","url":"https:\/\/community.smartsheet.com\/profile\/Kris%20Peeters","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zzjX8w2dwDY!5FVWucGjaaQ!-sgJ3Uz0EeO","dateLastActive":"2023-07-31T19:46:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":30,"score":null,"hot":3381664822,"url":"https:\/\/community.smartsheet.com\/discussion\/108318\/count-to-show-the-high-priority-items","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108318\/count-to-show-the-high-priority-items","format":"Rich","lastPost":{"discussionID":108318,"commentID":388103,"name":"Re: Count to show the High Priority Items","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388103#Comment_388103","dateInserted":"2023-07-31T19:48:33+00:00","insertUserID":121230,"insertUser":{"userID":121230,"name":"Kris Peeters","url":"https:\/\/community.smartsheet.com\/profile\/Kris%20Peeters","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zzjX8w2dwDY!5FVWucGjaaQ!-sgJ3Uz0EeO","dateLastActive":"2023-07-31T19:46:31+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\/382QSC10NTUW\/count-jpg.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"count.JPG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-31T19:48:14+00:00","dateAnswered":"2023-07-31T19:18:51+00:00","acceptedAnswers":[{"commentID":388092,"body":"
Travis Employee
