供公众使用的新模板
我想把这个模板变成社区的智能表。它适用于家庭活动，包含多种数据，如房间可用性、价格、减税、套餐和带表格的房间分配。我不知道该怎么捐，但我很想捐，因为它很适合家庭聚会。
4年内不会再做了，因为我们花了2万美元组装，但我想下次我会改进的。
我想知道我怎样才能提交新的模板来获得更多的用户，因为这个公司需要成长，需要成长(詹姆斯弗兰科)
在这里:
https://app.smartsheet.com/b/publish?EQBCT=b49759a23882467c896ee884e9edbb8e
形式:
https://app.smartsheet.com/b/form/3bf1110666c2408fb8c2e9ef2e844984
R
Nickelas
评论
-
Shaine格林伍德 员工嗨Nickelas,
谢谢分享你的作品。如果您有时间，您可以分享用于创建此工作表和表单的步骤，然后其他社区成员可以在需要时重新构建它。
类别
My apologies, I was counting interviews remaining in the current week. This will give you total interviews for the current week.<\/p>
=COUNTIFS([Interview Date]:[Interview Date], @cell <= TODAY(7 - WEEKDAY(TODAY())), [Interview Date]:[Interview Date], @cell > TODAY() - WEEKDAY(TODAY()), Fleet:Fleet, \"A220\")<\/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":254,"urlcode":"Formulas","name":"Formulas"}]},{"discussionID":106699,"type":"question","name":"Bridge Smartsheet Salesforce integration - redirect uri mismatch","excerpt":"Hello, I am trying to setup the Bridge Smartsheet Salesforce integration. I have followed the Smartsheet provided instructions at https:\/\/help.smartsheet.com\/articles\/2482029-salesforce-integration-overview-bridge to setup the Salesforce Connected App. I get the redirect uri mismatch error which says the redirect uri must…","categoryID":343,"dateInserted":"2023-06-21T15:05:04+00:00","dateUpdated":"2023-06-21T16:04:12+00:00","dateLastComment":"2023-06-22T04:28:35+00:00","insertUserID":134877,"insertUser":{"userID":134877,"name":"Neil Egsgard","url":"https:\/\/community.smartsheet.com\/profile\/Neil%20Egsgard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5tveebqufHw!ZEFfmXK0aXw!Dn7gBkJjOOH","dateLastActive":"2023-06-22T04:28:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":91566,"lastUserID":134877,"lastUser":{"userID":134877,"name":"Neil Egsgard","url":"https:\/\/community.smartsheet.com\/profile\/Neil%20Egsgard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5tveebqufHw!ZEFfmXK0aXw!Dn7gBkJjOOH","dateLastActive":"2023-06-22T04:28:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":22,"score":null,"hot":3374768619,"url":"https:\/\/community.smartsheet.com\/discussion\/106699\/bridge-smartsheet-salesforce-integration-redirect-uri-mismatch","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106699\/bridge-smartsheet-salesforce-integration-redirect-uri-mismatch","format":"Rich","tagIDs":[277,369],"lastPost":{"discussionID":106699,"commentID":381677,"name":"Re: Bridge Smartsheet Salesforce integration - redirect uri mismatch","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381677#Comment_381677","dateInserted":"2023-06-22T04:28:35+00:00","insertUserID":134877,"insertUser":{"userID":134877,"name":"Neil Egsgard","url":"https:\/\/community.smartsheet.com\/profile\/Neil%20Egsgard","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!5tveebqufHw!ZEFfmXK0aXw!Dn7gBkJjOOH","dateLastActive":"2023-06-22T04:28:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/B2DGWP3IILUP\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-22T04:28:43+00:00","dateAnswered":"2023-06-22T04:28:35+00:00","acceptedAnswers":[{"commentID":381677,"body":"
I solved the problem. A few key points:<\/p>
- The Callback URL in the instructions in Smartsheet Bridge - Salesforce Integration Overview<\/a> is wrong.<\/li>
- The correct Callback URL is: https:\/\/system.converse.ai\/api\/settings\/oauth\/oauth2callback<\/li>
- I was able to analyze the error message to determine the correct redirect URI which is also the required Callback URL.<\/li><\/ol>
Details of the solution<\/strong><\/p>
How I found the solution<\/em><\/p>
I determined the correct Callback URL by analyzing the Salesforce error that popped up when I clicked Connect on the Bridge.<\/p>
What I clicked to generate the error<\/em><\/p>
\n\n \n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/3ERTS4QF2F1J\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\nResulting error message<\/em><\/p>
I pulled the redirect URI from the message and added it to the Callback URL field in the Salesforce Connected App and that worked. See the second highlighted string.<\/p>
\n\n \n![\"image.png\"](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/Z4YTLT577UWC\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\nScreenshot of correct settings for the Salesforce Connected App<\/em><\/p>
Callback URL that works is:<\/p>
https:\/\/system.converse.ai\/api\/settings\/oauth\/oauth2callback<\/p>
![\"User:](\"https:\/\/us.v-cdn.net\/6031209\/uploads\/XP1EHRW1IOHX\/image.png\")
<\/img><\/a>\n <\/div>\n<\/div>\n
