添加插件和集成

询问有关控制中心、动态视图、数据网格、Pivot应用程序、日历应用程序、工作应用程序或资源管理的问题。讨论通过Bridge、Data Shuttle、Jira连接器和Salesforce连接器等集成将Smartsheet连接到其他系统。

类别

受欢迎的标签

When using a date value in a formula, you need to use the DATE function.<\/p>

=IF(CONTAINS(\"Meeting Package 4\", [Actualized Services (Awarded Call Tracker)]@row), IF([Date of Award Notification (Awarded Call Tracker)]@row > DATE(2021, 12, 08)<\/strong>, \"$100\"), \"$105\")<\/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":281,"urlcode":"Support","name":"Support"}]},{"discussionID":105364,"type":"question","name":"Multiple form submissions - update same row?","excerpt":"Hello, Here is the desired outcome I am looking for: Employee without access to the Smartsheet has access to a form, fills out the form, submits which then creates a new entry on the Smartsheet (which only managers can access) If employee needs to update their row in the future without having access to the Smartsheet, is…","categoryID":321,"dateInserted":"2023-05-17T17:54:52+00:00","dateUpdated":null,"dateLastComment":"2023-05-18T07:56:28+00:00","insertUserID":156129,"insertUser":{"userID":156129,"name":"EInoue","url":"https:\/\/community.smartsheet.com\/profile\/EInoue","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-17T20:48:16+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":8888,"lastUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-05-18T22:25:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":37,"score":null,"hot":3368744480,"url":"https:\/\/community.smartsheet.com\/discussion\/105364\/multiple-form-submissions-update-same-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105364\/multiple-form-submissions-update-same-row","format":"Rich","tagIDs":[204],"lastPost":{"discussionID":105364,"commentID":376386,"name":"Re: Multiple form submissions - update same row?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/376386#Comment_376386","dateInserted":"2023-05-18T07:56:28+00:00","insertUserID":8888,"insertUser":{"userID":8888,"name":"Andrée Starå","title":"Smartsheet Expert Consultant & Partner | Workflow Consultant \/ CEO @ WORK BOLD","url":"https:\/\/community.smartsheet.com\/profile\/Andr%C3%A9e%20Star%C3%A5","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/0PAU3GBYQLBT\/nXWM7QXGD6464.jpg","dateLastActive":"2023-05-18T22:25:54+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-17T20:48:26+00:00","dateAnswered":"2023-05-17T18:00:52+00:00","acceptedAnswers":[{"commentID":376284,"body":"

Hi @EInoue<\/a> <\/p>

I hope you're well and safe!<\/p>

The simplest option would be to use the Premium App, Dynamic View.<\/p>

Is that an option? <\/p>

I hope that helps!<\/p>

Be safe, and have a fantastic week!<\/p>

Best,<\/p>

Andrée Starå<\/strong><\/a> | Workflow Consultant \/ CEO @ WORK BOLD<\/strong><\/a><\/p>

Hey @Ken Armstrong<\/a> <\/p>

I'm glad to hear it's sorted on the new sheet, but that's definitely unexpected for your first version! If it happens again, please do reach out to Support with a screen recording and the affected sheet URL. <\/p>

Cheers,<\/p>

Genevieve<\/p>"},{"commentID":376453,"body":"