通知和其他通信不工作
亲爱的内容,
我有一个关于Smasrtsheet功能的简短演示,我在通知方面遇到了很大的问题。我有几张表,由于某种原因,所有通知都没有发送。
我正在尝试使用触发这些通知的字段,但它们都不工作。
我已经检查了我是否收到任何来自SS的电子邮件,当我发送单行时,它是好的,所以只有自动通知和请求是死的。
原因是什么?
想象一下,我站在老板面前告诉他,如果这个或那个不能正常工作,获得实时更新是多么棒……
评论
-
喀拉广告 员工
你好Mashu,
请转到帐户:个人设置:通知,并确保选择了包含您自己的更改的框(见下文)。如果这还不能解决问题,请告诉我们。
-
迈克Wilday ✭✭✭✭✭✭
如果你将通知设置为发送给自己,Kara是对的,这个设置是失败的首要原因。如果您继续有问题,请让社区知道!
-
Marcin P ✭
所有设置设置正确。
我收到一封来自支持的电子邮件,说有问题,但已经解决了。
事实上,我在一段时间前一个接一个地收到了所有通知。
-
迈克Wilday ✭✭✭✭✭✭
哦,是的。最近有通知方面的问题。
-
迈克Wilday ✭✭✭✭✭✭
您可以在这里查看系统状态:
-
彼得·史密斯 ✭
上次,我遇到了同样的问题。一切正常,但没有显示通知。然后,可能是30分钟,然后通知出来。希望你的系统更稳定
-
Marcin P ✭
这个问题一解决,我就收到了所有没有按时送达的通知。
但我对这个话题还有另一个问题:
如果我有一个用于填写考勤表的表单(员工必须输入他的名字并选择是否登记或退出),并且有同样的通知问题,这是否意味着通过网络表单发送的任何数据无论如何都会出现在考勤表中?
如果是这样,那还好,但如果有什么东西会丢失,那就不好了。
-
迈克Wilday ✭✭✭✭✭✭
通知是独立于网页表单的功能。只要Smartsheets没有出现系统范围的中断,无论通知是否触发,您都应该能够收集数据。
类别
Nested IF formulas read from left to right and stop on the first true value. So if you have In Progress in one child row and On Hold in another child row, it will register a true value with the In Progress argument, output that, then stop evaluating. If you want On Hold to \"override\" In Progress, you would need to adjust the order in which your IFs are nested.<\/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":106419,"type":"question","name":"SUMIFS not working (referencing another sheet)","excerpt":"I'm struggling with getting a SUMIFS function to work properly that is referencing another sheet. So on my sheet with the function, I have it as: =SUMIFS({Total GL Detail Range 4}, {Total GL Detail Range 5}, Project8, {Total GL Detail Range 3}, Title@row) ...where the \"Total GL Detail\" is the other sheet referenced. Range…","categoryID":322,"dateInserted":"2023-06-14T13:17:37+00:00","dateUpdated":null,"dateLastComment":"2023-06-14T20:49:20+00:00","insertUserID":162357,"insertUser":{"userID":162357,"name":"EBooher","url":"https:\/\/community.smartsheet.com\/profile\/EBooher","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-14T20:58:21+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"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-15T01:08:28+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":15,"countViews":104,"score":null,"hot":3373533417,"url":"https:\/\/community.smartsheet.com\/discussion\/106419\/sumifs-not-working-referencing-another-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106419\/sumifs-not-working-referencing-another-sheet","format":"Rich","lastPost":{"discussionID":106419,"commentID":380651,"name":"Re: SUMIFS not working (referencing another sheet)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/380651#Comment_380651","dateInserted":"2023-06-14T20:49:20+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-15T01:08:28+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-14T20:08:57+00:00","dateAnswered":"2023-06-14T18:51:01+00:00","acceptedAnswers":[{"commentID":380616,"body":"
Ok. I just had someone else earlier this week have the same issue. Even after converting all of the IDs to text it still wasn't working. Lets try converting everything on the source sheet to numbers. Take that LEFT formula you have that strips the ID out and wrap it in a VALUE function.<\/p>
=VALUE(LEFT(.......................))<\/p>
<\/p>
Then try the COUNTIFS on the ID again, but instead of referencing the helper cell in the formula sheet that we created, reference the linked cell that houses the numerical value.<\/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":[]}">