智能表复选箱自动化触发邮件通知

Cindi Meche
Cindi Meche ✭✭
内智能表基础知识

Hi智能表智能我需要你的帮助

智能表格填表请求假,包括邮箱有复选框(未包括在表内)识别管理批准程序框检查时,我想搭建自动化邮件寄送填表者

我能够搭建工作流到选择邮件字段点,但永远无法选择它我猜预想使用真的是一个列 下拉列表值但我只希望它通知提交者表

屏幕截图2023-05-17103357.jpg

有谁为我推荐吗

感谢邦奇

标签 :
· 分享脸书 分享Twitter

最佳答案

  • 肯纳市
    肯纳市 ✭✭
    回答

    i实际使用类型函数 并在这里我如何搭建它员工填写请假表时,你提到他们正在输入他们的邮箱地址将列设置为链式链表需要时可输入所有使用表的员工,并选择单价表唯一选项,通过只使用适当格式保持工作表净化,而不是对Dan、Danny、Daniel等人工输入输入同一个人-并允许你正确排序并运行干净报表Smartsheet后会提供联系列表列(无论标题如何)选项选择发送到该单元格中的人

    图像.png


    好运

    · 分享脸书 分享Twitter
  • jmhoward市
    jmhoward市 ✭✭✭✭✭
    回答

    使用批发工作流处理, 但仍需要联系域用户从下拉列表中选择名字并接收一则消息一经批准后接收一则消息和一则拒绝后接收一则消息

    图像.png

    工作表内有一栏“管理员核准?” 自动列表“核准”系统Cated日期和修改日期栏跟踪请求提交时间和批准时间

    · 分享脸书 分享Twitter

答案解析

  • 肯纳市
    肯纳市 ✭✭
    回答

    i实际使用类型函数 并在这里我如何搭建它员工填写请假表时,你提到他们正在输入他们的邮箱地址将列设置为链式链表需要时可输入所有使用表的员工,并选择单价表唯一选项,通过只使用适当格式保持工作表净化,而不是对Dan、Danny、Daniel等人工输入输入同一个人-并允许你正确排序并运行干净报表Smartsheet后会提供联系列表列(无论标题如何)选项选择发送到该单元格中的人

    图像.png


    好运

    · 分享脸书 分享Twitter
  • 肯阿姆斯特朗
    肯阿姆斯特朗 ✭✭✭✭✭✭

    列必须是联系链列类型才能工作确定那些您想加入联系链列的用户或许可用户或无许可用户,或必须在联系列内添加这些用户

    肯阿姆斯特朗

    sr系统分析员 Carelon医疗福利管理

    认证智能表管理员

    稳健点公平点友情点诚实点

    · 分享脸书 分享Twitter
  • AndréeStar
    AndréeStar ✭✭✭✭✭✭

    HiCindiMeche

    我希望你安然无恙

    可设置表单以便他们登录访问它, 后如果你添加系统列CreatedBy, 您可以在工作流使用它发送警告

    工作/帮助

    希望那有帮助

    安全周快乐

    最优

    AndréeStar工作流咨询/CEO@工作编程

    ✅我的文章帮助或回答你的问题或解决你的问题吗?请求支持社区深思熟虑/VoteUp、Sweet或/.会更容易为他人寻找解答或帮助解答

    SmarthheET专家咨询方和伙伴

    https://workbold.com/

    AndréeStar工作流咨询/CEO@工作编程

    W:www.workbold.comE:[email protected]P:+46(0)-72-5109935

    自由联系我 帮助智能表整合 通用工作流建议 或完全别的东西

    · 分享脸书 分享Twitter
  • jmhoward市
    jmhoward市 ✭✭✭✭✭
    回答

    使用批发工作流处理, 但仍需要联系域用户从下拉列表中选择名字并接收一则消息一经批准后接收一则消息和一则拒绝后接收一则消息

    图像.png

    工作表内有一栏“管理员核准?” 自动列表“核准”系统Cated日期和修改日期栏跟踪请求提交时间和批准时间

    · 分享脸书 分享Twitter

类别分类

固定值, 需在公式前添加\'vale\'


/p

=VALUE(IFERROR(JOIN(DISTINCT(COLLECT([Customer PO Amount (USD)]@row:[Customer PO Amount (Local Currency)]@row, [Customer PO Amount (USD)]@row:[Customer PO Amount (Local Currency)]@row, <>\"\"))), \" \"))<\/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":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":109460,"type":"question","name":"IF \/ OR formula then Check a Box","excerpt":"I need a formula that IF a specific column has either 1 of 2 specific choices, then a BOX in another column is checked: =IF(([Study Status]@row = \"Active\/ Open to Accrual\", 1) OR([Study Status]@row = \"In Start-Up\", 1))","snippet":"I need a formula that IF a specific column has either 1 of 2 specific choices, then a BOX in another column is checked: =IF(([Study Status]@row = \"Active\/ Open to Accrual\", 1)…","categoryID":321,"dateInserted":"2023-08-25T13:30:39+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T16:21:27+00:00","insertUserID":9250,"insertUser":{"userID":9250,"name":"Susan Swisher","url":"https:\/\/community.smartsheet.com\/profile\/Susan%20Swisher","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-08-25T16:23:49+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":null,"lastUserID":161714,"lastUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-26T01:04:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":9,"countViews":45,"score":null,"hot":3385956126,"url":"https:\/\/community.smartsheet.com\/discussion\/109460\/if-or-formula-then-check-a-box","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109460\/if-or-formula-then-check-a-box","format":"Rich","tagIDs":[254],"lastPost":{"discussionID":109460,"commentID":392616,"name":"Re: IF \/ OR formula then Check a Box","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392616#Comment_392616","dateInserted":"2023-08-25T16:21:27+00:00","insertUserID":161714,"insertUser":{"userID":161714,"name":"Carson Penticuff","url":"https:\/\/community.smartsheet.com\/profile\/Carson%20Penticuff","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B0Q390EZX8XK\/nBGT0U1689CN6.jpg","dateLastActive":"2023-08-26T01:04:51+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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-25T15:13:03+00:00","dateAnswered":"2023-08-25T14:14:39+00:00","acceptedAnswers":[{"commentID":392575,"body":"

试一下:++/p

=IF(OR([Study Status]@row = \"Active\/Open to Accrual\", [Study Status]@row = \"In Start-Up\"), 1)<\/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":254,"urlcode":"formulas","name":"Formulas"}]},{"discussionID":109457,"type":"question","name":"Conditional Formatting (modified date not in the last 3 weeks)","excerpt":"I would like to use Conditional Formatting (highlight the entire row yellow) if the modified date is not within the last 3 weeks.任何最近未更新行(最近3周)都用黄标注可直接条件格式化或我应先创建.snippe: "如果修改日期不在最近3周内,我想使用条件格式化(全行高亮黄色)So any row that has not been recently updated…","categoryID":321,"dateInserted":"2023-08-25T12:33:14+00:00","dateUpdated":null,"dateLastComment":"2023-08-25T12:40:57+00:00","insertUserID":161267,"insertUser":{"userID":161267,"name":"Jef Snyders","title":"Jef Snyders","url":"https:\/\/community.smartsheet.com\/profile\/Jef%20Snyders","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4HJAEW33KBD0\/nXEKEZE5EQEV4.jpg","dateLastActive":"2023-08-25T13:32:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":161267,"lastUser":{"userID":161267,"name":"Jef Snyders","title":"Jef Snyders","url":"https:\/\/community.smartsheet.com\/profile\/Jef%20Snyders","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4HJAEW33KBD0\/nXEKEZE5EQEV4.jpg","dateLastActive":"2023-08-25T13:32:31+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":26,"score":null,"hot":3385935251,"url":"https:\/\/community.smartsheet.com\/discussion\/109457\/conditional-formatting-modified-date-not-in-the-last-3-weeks","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/109457\/conditional-formatting-modified-date-not-in-the-last-3-weeks","format":"Rich","tagIDs":[437],"lastPost":{"discussionID":109457,"commentID":392553,"name":"Re: Conditional Formatting (modified date not in the last 3 weeks)","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/392553#Comment_392553","dateInserted":"2023-08-25T12:40:57+00:00","insertUserID":161267,"insertUser":{"userID":161267,"name":"Jef Snyders","title":"Jef Snyders","url":"https:\/\/community.smartsheet.com\/profile\/Jef%20Snyders","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4HJAEW33KBD0\/nXEKEZE5EQEV4.jpg","dateLastActive":"2023-08-25T13:32: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":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-25T12:40:09+00:00","dateAnswered":"2023-08-25T12:37:47+00:00","acceptedAnswers":[{"commentID":392551,"body":"

无法直接实现添加复选框辅助列类似内容并基于复选框格式化是最简单的方式甚至可以隐藏额外列,因为没有理由可见.++/p

=IF([Modified Date]@row < TODAY(-21), 1, 0)<\/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":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=321&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&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":4991,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

智能表基础知识趋势

  • JOIN ()公式结果-生成套接字

    问题涉及SmartSheet内JOIN公式使用问题,当公式输出复制到另一页时,该公式将包含不想要的批量JOIN函数设计归并值,但在此假设中,拷贝数据显示非.

  • IF/OR公式

    IF二分之一选取box后再校验:IF([Studystatus]@row=Accriptive/Open

  • 条件格式化(修改日期不是最后3周)

    条件格式化(高亮全行黄色),如果修改日期不在最近3周内使用任何最近未更新行(最近3周)都用黄标注spmessing直接在条件格式化内实现或我应先创建

帮助构建Smartshe
分享思想特征请求

 看视频