Looking for Pivot Table Feature in Smartsheet

A comma is needed between each range to sum.<\/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":107852,"type":"question","name":"Automation - Email to address in Smartsheet Column","excerpt":"I am trying to send an automatic email when something changes in the Smartsheet. I want to send the email to the email address in one of the columns, however, the only option I'm given is to send it to the \"Submitter\". However that is a generic user and not an email address. How do I get it to send to the email address in…","snippet":"I am trying to send an automatic email when something changes in the Smartsheet. I want to send the email to the email address in one of the columns, however, the only option I'm…","categoryID":321,"dateInserted":"2023-07-20T13:02:32+00:00","dateUpdated":null,"dateLastComment":"2023-07-20T13:46:35+00:00","insertUserID":159640,"insertUser":{"userID":159640,"name":"Katherine Simpson","url":"https:\/\/community.smartsheet.com\/profile\/Katherine%20Simpson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/EY1XYADLUP90\/n8693BY7J2F39.jpg","dateLastActive":"2023-07-20T13:42:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":159640,"lastUser":{"userID":159640,"name":"Katherine Simpson","url":"https:\/\/community.smartsheet.com\/profile\/Katherine%20Simpson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/EY1XYADLUP90\/n8693BY7J2F39.jpg","dateLastActive":"2023-07-20T13:42:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":31,"score":null,"hot":3379720147,"url":"https:\/\/community.smartsheet.com\/discussion\/107852\/automation-email-to-address-in-smartsheet-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107852\/automation-email-to-address-in-smartsheet-column","format":"Rich","lastPost":{"discussionID":107852,"commentID":386159,"name":"Re: Automation - Email to address in Smartsheet Column","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386159#Comment_386159","dateInserted":"2023-07-20T13:46:35+00:00","insertUserID":159640,"insertUser":{"userID":159640,"name":"Katherine Simpson","url":"https:\/\/community.smartsheet.com\/profile\/Katherine%20Simpson","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/EY1XYADLUP90\/n8693BY7J2F39.jpg","dateLastActive":"2023-07-20T13:42:54+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\/GT3Q99KUB51B\/automation-screenshot.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Automation Screenshot.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-20T13:46:21+00:00","dateAnswered":"2023-07-20T13:25:12+00:00","acceptedAnswers":[{"commentID":386141,"body":"

Hello @Katherine Simpson<\/a> <\/p>

You didn't specify how you are getting an email address in that cell, but here's some ideas.<\/p>

There's a couple ways to go about it. A lookup function based on some criteria to select who to send it to. Possibly adding a option to select who to email within the form. Manually entering an email. A couple options through automations would be to specify who to send it to or input a constant email address by using the change cell value.<\/p>

The column type has to be a Contact List too.<\/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":107845,"type":"question","name":"Smartsheet Form","excerpt":"Hi all, I've set up a new smartsheet with a form, the form isnt populating the sheet. The data is not appearing at the end of the rows, there is not conditional formatting to cause any 'invisible' data. The settings (screenshot attached) all seem fine. Any suggestions?","snippet":"Hi all, I've set up a new smartsheet with a form, the form isnt populating the sheet. The data is not appearing at the end of the rows, there is not conditional formatting to…","categoryID":321,"dateInserted":"2023-07-20T11:36:13+00:00","dateUpdated":null,"dateLastComment":"2023-07-20T12:29:32+00:00","insertUserID":148086,"insertUser":{"userID":148086,"name":"Lisa B 2022","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Lisa%20B%202022","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxbls3ea1kMuE-s37Yj-hmWMgVFXC1jOGRq6oYZd=s96-c","dateLastActive":"2023-07-20T11:44:04+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-07-20T20:14:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":31,"score":null,"hot":3379712145,"url":"https:\/\/community.smartsheet.com\/discussion\/107845\/smartsheet-form","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107845\/smartsheet-form","format":"Rich","tagIDs":[204],"lastPost":{"discussionID":107845,"commentID":386129,"name":"Re: Smartsheet Form","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/386129#Comment_386129","dateInserted":"2023-07-20T12:29:32+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-07-20T20:14:05+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-07-20T11:45:03+00:00","dateAnswered":"2023-07-20T11:43:24+00:00","acceptedAnswers":[{"commentID":386113,"body":"

Hi @Lisa B 2022<\/a> <\/p>

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

• Have you scrolled all the way down to the bottom of the sheet?<\/li>
• Also, have you checked the Activity Log so the submission is added to the sheet?<\/li><\/ul>

  Did 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":[{"tagID":204,"urlcode":"Forms","name":"Forms"}]}],"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":4861,"limit":3},"title":"Trending in Smartsheet Basics","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">

  Trending in Smartsheet Basics

  • Using Sum function on 2 referring pages

    I am trying to sum to different cells on 2 different Smart Sheets and I I keep on getting a #UNPARSEABLE error. It works fine when it references only 1 sheet but I need to sum probably about 20+ sheets when I am done. Just testing with 2 right now. Any help is appreciated =SUM({AAA Pet Services - Sign Ups Range 1}{AAA Pet…

  • Automation - Email to address in Smartsheet Column

    I am trying to send an automatic email when something changes in the Smartsheet. I want to send the email to the email address in one of the columns, however, the only option I'm given is to send it to the "Submitter". However that is a generic user and not an email address. How do I get it to send to the email address in…

  • Smartsheet Form

    Hi all, I've set up a new smartsheet with a form, the form isnt populating the sheet. The data is not appearing at the end of the rows, there is not conditional formatting to cause any 'invisible' data. The settings (screenshot attached) all seem fine. Any suggestions?