电话号码格式化(###-###-####)

是否有一种方法将一列数字格式化为电话号码格式?NPA-NXX-NNNN吗?

标签:

答案

Hey Evan, when you select your data source for your chart, be sure to select just the cells, not the columns. You also may need to toggle on that Switch Rows and Columns setting. And toggle off the Use column names setting.<\/p>


<\/p>

Here's mine displaying the cell value rather than the column value...<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n


<\/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":[]},{"discussionID":105671,"type":"question","name":"Email automation with PARENT\/CHILD data from pivot table","excerpt":"I'm trying to create an output of specific rows of a pivot table to attach\/include in an automated email. See below for an example table I'd like to extract from the master pivot table. The \"Alert someone\" automation allows me to specify which cell information I want to include but does not seem to be able to allow for…","categoryID":321,"dateInserted":"2023-05-24T20:30:05+00:00","dateUpdated":null,"dateLastComment":"2023-05-30T07:26:55+00:00","insertUserID":152100,"insertUser":{"userID":152100,"name":"ShannonL","url":"https:\/\/community.smartsheet.com\/profile\/ShannonL","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!BDfYwfm-KLw!x-nfsdxDXj4!WF1ZpbcVLlX","dateLastActive":"2023-05-30T11:50:52+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-30T13:17:46+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":10,"countViews":93,"score":null,"hot":3370397820,"url":"https:\/\/community.smartsheet.com\/discussion\/105671\/email-automation-with-parent-child-data-from-pivot-table","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105671\/email-automation-with-parent-child-data-from-pivot-table","format":"Rich","tagIDs":[254,334,335,448],"lastPost":{"discussionID":105671,"commentID":377870,"name":"Re: Email automation with PARENT\/CHILD data from pivot table","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377870#Comment_377870","dateInserted":"2023-05-30T07:26:55+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-30T13:17:46+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/M5GUWQGDZLN3\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-30T08:25:24+00:00","dateAnswered":"2023-05-26T18:49:09+00:00","acceptedAnswers":[{"commentID":377765,"body":"

@ShannonL<\/a> <\/p>

Happy to help!<\/p>

You can set that up in that option. (see below)<\/p>

\n
\n \n \"image.png\"<\/img><\/a>\n <\/div>\n<\/div>\n

Would that work?<\/p>

Remember! <\/strong>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":[{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"tagID":335,"urlcode":"sheet-summary","name":"Sheet Summary"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]},{"discussionID":105606,"type":"question","name":"How can I change the spacing of tick marks on the x axis as one per day is too many?","excerpt":"The daily measurements are too many showing to read the dates. How can I fix this to have the chart adjust to the number of data points?","categoryID":321,"dateInserted":"2023-05-23T19:00:48+00:00","dateUpdated":null,"dateLastComment":"2023-05-29T13:41:02+00:00","insertUserID":161727,"insertUser":{"userID":161727,"name":"m.loeffler","title":"Consultant","url":"https:\/\/community.smartsheet.com\/profile\/m.loeffler","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-05-26T20:49:41+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-05-30T12:09:43+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":95,"score":null,"hot":3370240310,"url":"https:\/\/community.smartsheet.com\/discussion\/105606\/how-can-i-change-the-spacing-of-tick-marks-on-the-x-axis-as-one-per-day-is-too-many","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/105606\/how-can-i-change-the-spacing-of-tick-marks-on-the-x-axis-as-one-per-day-is-too-many","format":"Rich","lastPost":{"discussionID":105606,"commentID":377843,"name":"Re: How can I change the spacing of tick marks on the x axis as one per day is too many?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/377843#Comment_377843","dateInserted":"2023-05-29T13:41: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-05-30T12:09:43+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,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/C6J8INDNPA2D\/image.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"image.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-05-26T20:49:39+00:00","dateAnswered":"2023-05-24T13:43:24+00:00","acceptedAnswers":[{"commentID":377339,"body":"

@m.loeffler<\/a> So what you would do here is make a helper column that has a date in every 4 rows, and leave the others blank. Then make that your farther left column. When you add the chart and you click the option that says use the first column as data labels, it should be spaced out more.<\/p>

If that doesn't make sense, I can send an example.<\/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":[]}],"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

使用Smartsheet的趋势