文档生成器-日期格式?

罗宾Sugiura
罗宾Sugiura ✭✭✭
编辑06/14/22 在添加插件和集成

我试图与文件生成器生成完成证书，并包括授予的日期。无论我如何在日期字段中输入日期(我的首选格式是“星期五，2021年1月1日”)，它总是以1/1/21格式输入。有什么办法让文档生成器正确地填充它吗?

· 在Facebook上分享 在Twitter上分享

最佳答案

  • 罗宾Sugiura
    罗宾Sugiura ✭✭✭
    ✓回答

    我想出了一个变通办法——如果在文本列而不是日期列中以长格式输入日期，则会按照输入的方式进行填充。

    不知道是否有其他方法可以影响从日期列填充的格式。

    · 在Facebook上分享 在Twitter上分享

答案

  • 罗宾Sugiura
    罗宾Sugiura ✭✭✭
    ✓回答

    我想出了一个变通办法——如果在文本列而不是日期列中以长格式输入日期，则会按照输入的方式进行填充。

    不知道是否有其他方法可以影响从日期列填充的格式。

    · 在Facebook上分享 在Twitter上分享
  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    嗨@Robin Sugiura

    太好了!

    很高兴你让它工作，感谢分享解决方案。

    注意安全，祝你度过美好的一周!

    最好的

    她名叫Stara|工作流程顾问/ CEO @工作大胆

    ✅请通过标记你的帖子来帮助社区与公认的答案/有用的．这将使其他人更容易找到解决方案或帮助回答!

    智能表专家顾问兼合伙人

    https://workbold.com/

    她名叫Stara|工作流程顾问/ CEO @工作大胆

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。

    · 在Facebook上分享 在Twitter上分享
  • 艾玛McCannan
    艾玛McCannan ✭

    我正在努力解决这个线程中列出的相同问题，但我的问题是我无法将日期添加为文本，因为还有其他列自动从日期列计算。我能否以某种方式将日期复制到文本列中而不会遇到格式问题?

    · 在Facebook上分享 在Twitter上分享
  • 罗宾Sugiura
    罗宾Sugiura ✭✭✭

    是的，我必须添加一个助手列，必须手动添加长格式版本。这是一种糟糕的变通方法。

    · 在Facebook上分享 在Twitter上分享
  • 亚历克西斯Kokkinos
    亚历克西斯Kokkinos ✭

    嗨。我有一个类似的问题，我想以长格式显示修改后的日期。我通过构建一个包含月份的表格来解决这个问题(第1列是数字1到12，第2列是月份名称)。然后，我在我的工作表中使用了一个新的列，其公式如下=DAY()(电子邮件保护)) + " " + vlookup (month ())(电子邮件保护))， {Months Range 1}， 2, false) + " " + YEAR((电子邮件保护))。这将返回长格式的文本，我在文档构建器中使用它。它很干净，很容易使用。如果我们可以简单地格式化为“长”，那就更好了:)

    · 在Facebook上分享 在Twitter上分享
  • 克里斯汀•海
    克里斯汀•海 ✭

    从格式化的角度来看，我发现文档构建器非常令人沮丧，这就是其中之一。这些变通方法与它们所呈现的特性并不一致——它远没有看上去那么简单。我的格式是通过各种拉伸大小，文本切断在表单字段，等等。需要有一个只影响文档的格式编辑功能，而不需要源工作表具有相同的格式(文本对齐、字体大小等)。

    · 在Facebook上分享 在Twitter上分享
  • SueinSpain
    SueinSpain ✭✭✭✭✭

    我有日期格式问题，发现这是因为格式取自PDF文件，而不是智能表。所以我在我的adobe可填充pdf中做了一个自定义日期格式，然后它就工作了。

    我没有尝试过所有的变化或非常长的日期，但它确实让我意识到PDF格式覆盖了智能表格式


    希望这对你有帮助:)

    苏罗杰斯

    AmerisourceBergen - MWI动物健康

    业务分析师

    · 在Facebook上分享 在Twitter上分享
  • 尼古拉斯·米歇尔
    尼古拉斯·米歇尔 ✭✭✭

    @SueinSpain我对你使用的日期格式很感兴趣。你说的我都试过了。我将pdf中的字段修改为date DD-MM - yyyy(与我在工作表中的列日期格式相同)，并重新映射了它，但生成的表单仍然显示DD/MM/YY(欧洲)和MM/DD/YY(美国同事)的日期。看起来，日期区域设置是生成文档时用于日期列的默认格式。

    · 在Facebook上分享 在Twitter上分享
  • 给
    给 ✭✭✭✭✭✭

    我的任务是创建美国格式的文档，即使我在英国。

    你能帮忙吗?@Andree Stara？

    · 在Facebook上分享 在Twitter上分享
  • 她名叫Stara
    她名叫Stara ✭✭✭✭✭✭

    嗨@Kirstine

    我希望你一切安好!

    事情进展如何?你安排好什么了吗?

    我希望这对你有帮助!

    祝你周末愉快，新年快乐!

    最好的

    她名叫Stara|工作流程顾问/ CEO @工作大胆

    智能表专家顾问兼合伙人

    https://workbold.com/

    她名叫Stara|工作流程顾问/ CEO @工作大胆

    W:www.workbold.com| E:(电子邮件保护)| p: +46 (0) - 72 - 510 99 35

    请随时与我联系，了解有关Smartsheet，集成，一般工作流建议或其他方面的帮助。

    · 在Facebook上分享 在Twitter上分享
  • 给
    给 ✭✭✭✭✭✭

    嗨@Andree Stara

    我仍然不能让它做一个长日期，但我做了一个可笑的解决办法，用三个辅助列，至少带来了英文格式。(我需要在句尾输入我的句子，所以我必须在后面加一个句号/句号。)

    Date_helper1: =([起始日期]@row) + " "

    Date_helper2: = "。"

    Date_helper3: =LEFT([Date_helper1]@row, 8) + [Date_helper2]@row

    · 在Facebook上分享 在Twitter上分享
  • 吉纳维芙·范·布勒
    吉纳维芙·范·布勒 ✭

    我已经将PDF格式更新为mm/dd, yyyy，并将智能表格式更改为长格式，文档生成器中的日期仍然显示为mm/dd/yy

    · 在Facebook上分享 在Twitter上分享
  • damon.tackett
    damon.tackett ✭

    令人震惊的是，这仍然是个问题。Smartsheet在很多方面都很棒，但事实上，从日期列获取信息并使用源列中已经设置的格式将其传输到文档构建器中是非常令人惊讶的。这是一个众所周知的问题…三年了?任何其他专栏似乎都能准确地获取来源信息。

    我在其他地方看到它是基于你的个人资料偏好，但在查看了无数的地区偏好后，我没有看到一个甚至被设置为MM/DD/YYYY。来吧，伙计们.....如果这就是格式的基础，那么添加一个使用该格式的。最好还是添加一个使用MM/DD/YYYY的，另一个使用月/日/年(2023年1月1日以前)的。

    · 在Facebook上分享 在Twitter上分享

类别

Ah. Ok. I had a very different idea of the data structure, so the screenshot definitely helps. Try this:<\/p>

=IF([Task 1]@row <> \"Completed\", \"Team 1\" + CHAR(10), \"//www.santa-greenland.com/community/discussion/comment/\") + IF([Task 2]@row <> \"Completed\", \"Team 2\" + CHAR(10), \"//www.santa-greenland.com/community/discussion/comment/\") + IF([Task 3]@row <> \"Completed\", \"Team 3\" + CHAR(10), \"//www.santa-greenland.com/community/discussion/comment/\") + IF([Task 4]@row <> \"Completed\", \"Team 4\", \"//www.santa-greenland.com/community/discussion/comment/\")<\/p>


<\/p>

The difference above as compared to typical IF statements is that usually they are nested, but in this case we want to \"add\" them together.<\/p>


<\/p>

NOTE: CHAR(10) is the built in delimiter for multi-select columns and will allow each team to be treated as an individual selection within the cell in the event you need to filter or report on it.<\/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":334,"urlcode":"automations","name":"Automations"}]},{"discussionID":106762,"type":"question","name":"Data Shuttle Update Rows Workflow: Preventing Duplicate Updates","excerpt":"Hi all, I have a data shuttle update workflow that runs on a schedule updating rows in the target Smartsheet as they change in an excel source file stored in Box. I wanted to see if there was a way to somehow configure the data shuttle workflow so once a row has been updated, it can't be changed again. I tried doing this…","categoryID":321,"dateInserted":"2023-06-22T12:23:57+00:00","dateUpdated":null,"dateLastComment":"2023-06-22T13:14:54+00:00","insertUserID":162120,"insertUser":{"userID":162120,"name":"cko","url":"https:\/\/community.smartsheet.com\/profile\/cko","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T12:17:10+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-23T14:42:55+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":36,"score":null,"hot":3374878131,"url":"https:\/\/community.smartsheet.com\/discussion\/106762\/data-shuttle-update-rows-workflow-preventing-duplicate-updates","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106762\/data-shuttle-update-rows-workflow-preventing-duplicate-updates","format":"Rich","tagIDs":[474],"lastPost":{"discussionID":106762,"commentID":381734,"name":"Re: Data Shuttle Update Rows Workflow: Preventing Duplicate Updates","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381734#Comment_381734","dateInserted":"2023-06-22T13:14:54+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-23T14:42:55+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-06-22T17:00:56+00:00","dateAnswered":"2023-06-22T12:42:28+00:00","acceptedAnswers":[{"commentID":381723,"body":"

You would need to use a Move Row or Copy Row automation.<\/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":474,"urlcode":"data-shuttle","name":"Data Shuttle"}]},{"discussionID":106686,"type":"question","name":"Creating a form with multiple entries","excerpt":"Hi, So my issue is, I have a form that is designed to record incoming invoices. I need the form to firstly attach a number of invoices and create multiple entries. I've seen some ways to do this using another sheet and automation. The only problem with this is the form has to have pdf uploads of the invoices. So I'm not…","categoryID":321,"dateInserted":"2023-06-21T12:49:14+00:00","dateUpdated":null,"dateLastComment":"2023-06-23T09:36:48+00:00","insertUserID":162427,"insertUser":{"userID":162427,"name":"Zachwalters99","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Zachwalters99","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T09:39:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162427,"lastUser":{"userID":162427,"name":"Zachwalters99","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Zachwalters99","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T09:39:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":31,"score":null,"hot":3374866562,"url":"https:\/\/community.smartsheet.com\/discussion\/106686\/creating-a-form-with-multiple-entries","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106686\/creating-a-form-with-multiple-entries","format":"Rich","lastPost":{"discussionID":106686,"commentID":381901,"name":"Re: Creating a form with multiple entries","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/381901#Comment_381901","dateInserted":"2023-06-23T09:36:48+00:00","insertUserID":162427,"insertUser":{"userID":162427,"name":"Zachwalters99","title":"Mr","url":"https:\/\/community.smartsheet.com\/profile\/Zachwalters99","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-23T09:39:03+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-06-23T09:30:18+00:00","dateAnswered":"2023-06-21T16:49:39+00:00","acceptedAnswers":[{"commentID":381537,"body":"

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

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

I developed a solution using two forms (or the same form by using conditional logic) that can be used to submit the main information and then the other information on a new row for each submission after the first.<\/p>

Would that work\/help? <\/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>

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by <\/em>marking it Insightful\/Vote Up, Awesome, or\/and as the accepted answer<\/em><\/strong>. It will make it easier for others to find a solution or help to answer!<\/em><\/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":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&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":5400,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势

  • 智能表自动化从多选择单元格中删除单个值

    我有多个列来表示任务;任务1，任务2，任务3，任务4。每个任务的单元格值可以为;已完成，进行中，未开始。然后，我有一个名为Team的多值下拉列，表示完成项目所需的团队。我有一个自动化的地方来添加团队…

  • 数据穿梭更新行工作流:防止重复更新

    嗨，我有一个数据穿梭更新工作流，它运行在一个时间表上更新行在目标智能表中，因为它们在存储在Box中的excel源文件中发生变化。我想看看是否有一种方法以某种方式配置数据穿梭工作流程，以便一旦一行被更新，它就不能再次更改。我试着这样做……

  • 创建包含多个条目的表单

    你好，我的问题是，我有一个用来记录发票的表格。我需要的形式，首先附加一些发票和创建多个条目。我已经看到了使用另一个表单和自动化的一些方法。唯一的问题是表单必须有pdf格式的发票上传。所以我不是…