使用智能表格进行拨款写作
评论
-
如果你能想象用微软excel来写拨款，我找不出你不能用它来写拨款的理由。
如果你无法想象用微软excel来写拨款申请你可能会看到一些更先进的东西，所以我会让更有知识的人来回答这部分。
-
Richard Rymill，收缩压 ✭✭✭✭✭✭Patrick，赠款申请审批，撰写这些批准的规格，然后用自己的kpi跟踪每个赠款批准的项目，这些都是Smartsheet确实做得很好的事情。
我们与慈善机构和NFPs合作，做类似的工作，所以我可以向你保证，你已经找到了适合这项工作的工具。
放手去做吧，享受实时协作的新自由。
RichardR
类别
You would need to use a third party app such as Zapier, the premium add-on Bridge, or the API to get it to work exactly like that.<\/p>
<\/p>
If you are ok with the link being in another column, you can use this formula:<\/p>
=\"www.acmetickets.com\/ticket\/\" + [Ticket Number Column Name]@row <\/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":[{"tagID":331,"urlcode":"hyperlink","name":"hyperlink"}]},{"discussionID":106493,"type":"question","name":"Need a formula to take a filename and alter the text","excerpt":"I need a formula that will take a filename and then remove the underscores and replace with periods and make the text lowercase. I am having trouble know what function to use to remove the underscores. Filename example: JK_T1_L1_NewFile The filename always follows this rules - 2 letters_2 letters__2 letters _filename I…","categoryID":322,"dateInserted":"2023-06-15T14:06:14+00:00","dateUpdated":"2023-06-15T14:15:38+00:00","dateLastComment":"2023-06-15T15:31:51+00:00","insertUserID":162413,"insertUser":{"userID":162413,"name":"kpierson109","url":"https:\/\/community.smartsheet.com\/profile\/kpierson109","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-15T14:14:32+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":162413,"lastUserID":45516,"lastUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-15T15:37:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":23,"score":null,"hot":3373682885,"url":"https:\/\/community.smartsheet.com\/discussion\/106493\/need-a-formula-to-take-a-filename-and-alter-the-text","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106493\/need-a-formula-to-take-a-filename-and-alter-the-text","format":"Rich","lastPost":{"discussionID":106493,"commentID":380824,"name":"Re: Need a formula to take a filename and alter the text","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380824#Comment_380824","dateInserted":"2023-06-15T15:31:51+00:00","insertUserID":45516,"insertUser":{"userID":45516,"name":"Paul Newcome","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Newcome","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/082\/nQPUTVFKKWDJ2.jpg","dateLastActive":"2023-06-15T15:37:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-15T15:34:11+00:00","dateAnswered":"2023-06-15T14:16:00+00:00","acceptedAnswers":[{"commentID":380785,"body":"
Try this:<\/p>
=LOWER(SUBSTITUTE([Column Name]@row, \"_\", \"\"))<\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&siteSectionID=0&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":10000,"limit":3},"title":"Trending Posts","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
