Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, pleaseVisit the Current Forums.
甘特图的时间问题
Hi there,
When I try to print a Gantt Chart the timeline is in, say, months or quarters, but when I press the printer icon it automatically converts to a weekly timeline. Does anyone know how to control the timeline when I print?
Thanks,
Paul
Comments
-
JamesR ✭✭✭✭✭✭Paul,
If you only have Editor or Viewer permissions then although you can change the time scale with the Zoom , if you print it uses the default set by the Administrator or Owner of the sheet.
-
Paul R ✭
Thanks James.
Categories
=IF(ISDATE([Due Date]@row), IF(OR([Severity]@row = \"Critical\", [Severity]@row = \"High\"), [Due Date]@row - 30, IF(OR([Severity]@row = \"Medium\", [Severity]@row = \"Low\"), [Due Date]@row - 90, \"\"))) <\/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":108321,"type":"question","name":"Generate Documents and Contact cells","excerpt":"Hi I have a fillable PDF and have mapped my fields. I have 4 columns that are Contact List properties. When I map those fields and test to make sure it is coming out correctly, it is showing the email address and not the contact name. What am I missing or doing wrong? Below is a screen shot","snippet":"Hi I have a fillable PDF and have mapped my fields. I have 4 columns that are Contact List properties. When I map those fields and test to make sure it is coming out correctly, it…","categoryID":321,"dateInserted":"2023-07-31T19:57:18+00:00","dateUpdated":null,"dateLastComment":"2023-08-01T12:54:02+00:00","insertUserID":127983,"insertUser":{"userID":127983,"name":"Carol-Anne Cerbone","url":"https:\/\/community.smartsheet.com\/profile\/Carol-Anne%20Cerbone","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!h1jY4Qxc4TY!prNYaQRZvvo!a6wiwaB2GsY","dateLastActive":"2023-08-01T12:56:19+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-08-01T12:51:40+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":17,"score":null,"hot":3381729680,"url":"https:\/\/community.smartsheet.com\/discussion\/108321\/generate-documents-and-contact-cells","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108321\/generate-documents-and-contact-cells","format":"Rich","tagIDs":[583],"lastPost":{"discussionID":108321,"commentID":388180,"name":"Re: Generate Documents and Contact cells","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388180#Comment_388180","dateInserted":"2023-08-01T12:54:02+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-08-01T12:51:40+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/4LPR5097N8PJ\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-08-01T12:26:39+00:00","dateAnswered":"2023-08-01T12:18:28+00:00","acceptedAnswers":[{"commentID":388169,"body":"
You will need to create some helper text\/number columns and use a basic cell reference to pull the name over.<\/p>
=[Contact Column Name]@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":583,"urlcode":"generate-documents","name":"#generate documents"}]},{"discussionID":108317,"type":"question","name":"Missing Attachment as Notification Trigger - Smartsheet Automations?","excerpt":"I have built out a multi-use form that, depending on the user, requires attachments to be added. Since I cannot conditionally require attachments in the form I am trying to build an automation that triggers a notification to the form submitter if they neglect to add an attachment when it is required... but I continue to…","snippet":"I have built out a multi-use form that, depending on the user, requires attachments to be added. Since I cannot conditionally require attachments in the form I am trying to build…","categoryID":321,"dateInserted":"2023-07-31T18:49:01+00:00","dateUpdated":null,"dateLastComment":"2023-07-31T21:45:08+00:00","insertUserID":150707,"insertUser":{"userID":150707,"name":"KT_H","url":"https:\/\/community.smartsheet.com\/profile\/KT_H","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp7r65MnQG4KHfpM6sDg02QZH9cQedVQiNKhYciZ=s96-c","dateLastActive":"2023-07-31T21:43:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"updateUserID":null,"lastUserID":150707,"lastUser":{"userID":150707,"name":"KT_H","url":"https:\/\/community.smartsheet.com\/profile\/KT_H","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp7r65MnQG4KHfpM6sDg02QZH9cQedVQiNKhYciZ=s96-c","dateLastActive":"2023-07-31T21:43:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":43,"score":null,"hot":3381673449,"url":"https:\/\/community.smartsheet.com\/discussion\/108317\/missing-attachment-as-notification-trigger-smartsheet-automations","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/108317\/missing-attachment-as-notification-trigger-smartsheet-automations","format":"Rich","tagIDs":[334],"lastPost":{"discussionID":108317,"commentID":388126,"name":"Re: Missing Attachment as Notification Trigger - Smartsheet Automations?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/388126#Comment_388126","dateInserted":"2023-07-31T21:45:08+00:00","insertUserID":150707,"insertUser":{"userID":150707,"name":"KT_H","url":"https:\/\/community.smartsheet.com\/profile\/KT_H","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AEdFTp7r65MnQG4KHfpM6sDg02QZH9cQedVQiNKhYciZ=s96-c","dateLastActive":"2023-07-31T21:43:52+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/UNL6146F51E4\/screen-shot-2023-07-31-at-11-47-52-am.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2023-07-31 at 11.47.52 AM.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-31T19:29:49+00:00","dateAnswered":"2023-07-31T19:25:26+00:00","acceptedAnswers":[{"commentID":388094,"body":"
Ok, how about using a helper column with a 0 or 1 being input by your automation, and then use this as the trigger. So set the default on the column to 0, and if an attachment is there, leave it at 0. Then if an attachment is not there workflow will set it to 1, and that would trigger the automated workflow to run.<\/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"}]}],"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":[]}">
