Finance

0,E3-C3,TODAY()-C3) this works great in excel but in smartsheet it comes back with #INVALID COLUMN VALUE can anyone help fix this issue?? Please see attached excel with formula in Column D Thank you in advance :) ","categoryID":322,"dateInserted":"2019-02-05T06:19:24+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-04-23T11:00:36+00:00","insertUserID":41351,"insertUser":{"userID":41351,"name":"Anna Mullins","url":"https:\/\/community.smartsheet.com\/profile\/Anna%20Mullins","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-03\/c6\/0e\/nc60eae9be62b12eb53439135e60f2271.PNG","dateLastActive":"2019-02-05T15:25:51+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-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":12,"countViews":369,"score":null,"hot":12,"url":"https:\/\/community.smartsheet.com\/discussion\/40586\/formula-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/40586\/formula-not-working","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-02\/ee\/fb\/eefb428415c3eeb9aaf289881d0445e1.JPG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"formula.JPG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":207,"urlcode":"sales","name":"Sales"},{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":279,"urlcode":"marketing","name":"Marketing"},{"tagID":324,"urlcode":"community-platform","name":"Community Platform"},{"tagID":437,"urlcode":"conditional-formatting","name":"Conditional Formatting"}],"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}]},{"discussionID":58286,"type":"discussion","name":"=SUMIF Month-to-Month","excerpt":"I am trying to create a graph for a Dashboard that will display the total amount of approved $$ within each month and total amount of denied $$ within each month. I will also need a rolling YTD total. So far this is what I have for the formula: =SUMIFS({RSA Form Range 2}, {RSA Form Range 9}, \"Green\", {RSA Form Range 3},…","categoryID":322,"dateInserted":"2019-09-23T14:40:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-04-21T20:01:58+00:00","insertUserID":103696,"insertUser":{"userID":103696,"name":"aalang103696","url":"https:\/\/community.smartsheet.com\/profile\/aalang103696","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!p_lDKTUw3jw!xYDCsU0h8tQ!PJ51JKHy0GN","dateLastActive":"2023-04-05T14:23:01+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":11,"countViews":1484,"score":null,"hot":11,"url":"https:\/\/community.smartsheet.com\/discussion\/58286\/sumif-month-to-month","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/58286\/sumif-month-to-month","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-09\/31\/9c\/319cac465f7ab492abe6fdd599493687.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Capture5.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":211,"urlcode":"manufacturing","name":"Manufacturing"},{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}]},{"discussionID":67502,"type":"question","name":"Calculating a minimum payment figure using a formula or function","excerpt":"Hello, I'm hoping someone may be able to help me with something that probably seems quite obvious or basic however, my knowledge on formulas or functions within Smartsheet is not advanced, so I apologise in advance! I'm trying to get my finances in order and thought I'd use Smartsheet to plan this. I've done a screen shot…","categoryID":322,"dateInserted":"2020-04-16T17:35:51+00:00","dateUpdated":null,"dateLastComment":"2020-04-20T13:04:16+00:00","insertUserID":78206,"insertUser":{"userID":78206,"name":"SteCoxy","url":"https:\/\/community.smartsheet.com\/profile\/SteCoxy","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!aTDbGqngcGQ!2wnbf5m83zw!VTDReGCjYpc","dateLastActive":"2023-08-21T11:32:27+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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":170,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/67502\/calculating-a-minimum-payment-figure-using-a-formula-or-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67502\/calculating-a-minimum-payment-figure-using-a-formula-or-function","format":"rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/389\/RH1Z6ACBINTN.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screenshot 2020-04-16 18.31.57.png"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-04-17T20:17:46+00:00","dateAnswered":"2020-04-17T11:53:28+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"sheets","name":"Sheets"},{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":319,"urlcode":"functionality","name":"functionality"}],"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}]},{"discussionID":26976,"type":"discussion","name":"Plotting cost over time","excerpt":"Hi- I am trying to either graphically or with subtotals display cost over time as aggregated preferably by month, but also want to consider by week. I am easily able to plot cost for items that begin or end in a calendar month, but not for items that span months. I am pretty sure each cost would need to be broken down into…","categoryID":322,"dateInserted":"2018-06-14T13:02:58+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-04-16T21:23:55+00:00","insertUserID":11374,"insertUser":{"userID":11374,"name":"Mike Liggett","url":"https:\/\/community.smartsheet.com\/profile\/Mike%20Liggett","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-06-14T12:57:35+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-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":956,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/26976\/plotting-cost-over-time","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/26976\/plotting-cost-over-time","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2018-06\/44\/f6\/44f67b77c0bf7aee344a1fe3386ca83e.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shot 2018-06-14 at 9.56.42 AM.png"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":241,"urlcode":"calendar","name":"Calendar View"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":265,"urlcode":"reports","name":"Reports"},{"tagID":292,"urlcode":"dashboards","name":"Dashboards"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}]},{"discussionID":67481,"type":"discussion","name":"Local Government Uses","excerpt":"I am a Mayor of the city in Washington. We are looking at Smartsheet to add as a project management tool for staff. I am interested in how other local governments are using Smartsheet? Specific areas of interest are Capital Projects, Human Resources (Performance Reviews?), Permit Tracking, and Finance. Brett","categoryID":321,"dateInserted":"2020-04-15T22:56:42+00:00","dateUpdated":null,"dateLastComment":"2020-04-15T22:56:42+00:00","insertUserID":120482,"insertUser":{"userID":120482,"name":"Brett Gailey","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Brett%20Gailey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/072\/nKK5PKQTPSKBM.png","dateLastActive":"2020-07-02T20:24:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":120482,"lastUser":{"userID":120482,"name":"Brett Gailey","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Brett%20Gailey","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/072\/nKK5PKQTPSKBM.png","dateLastActive":"2020-07-02T20:24:44+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":163,"score":null,"hot":0,"url":"https:\/\/community.smartsheet.com\/discussion\/67481\/local-government-uses","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67481\/local-government-uses","format":"rich","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":263,"urlcode":"government","name":"Government"}],"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}]},{"discussionID":58901,"type":"discussion","name":"Access Security for Forms","excerpt":"Does anyone know if there's a way to limit form access to a specific person or group of people. Or, is there something in the works at Smartsheet to address this? Looks like there is currently two options. * Anyone * Anyone with a Smartsheet login I use Smartsheet forms to submit project tasks (not too confidential) and…","categoryID":321,"dateInserted":"2019-09-30T11:30:01+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-04-15T16:35:46+00:00","insertUserID":73391,"insertUser":{"userID":73391,"name":"aaron.fye73391","url":"https:\/\/community.smartsheet.com\/profile\/aaron.fye73391","photoUrl":"https:\/\/lh3.googleusercontent.com\/a-\/AAuE7mDwPz6HMMsO1ckpOv3Fq6cT-E8d8L1kbl1H0w9vaQ","dateLastActive":"2020-02-09T04:04:58+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":31361,"lastUser":{"userID":31361,"name":"Lushenkm","url":"https:\/\/community.smartsheet.com\/profile\/Lushenkm","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2018-03\/28\/23\/n2823264853dab78e3928fcedb8963179.png","dateLastActive":"2020-04-23T18:03:05+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":6,"countViews":1316,"score":null,"hot":6,"url":"https:\/\/community.smartsheet.com\/discussion\/58901\/access-security-for-forms","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/58901\/access-security-for-forms","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":216,"urlcode":"non-profit","name":"Non-profit"},{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":273,"urlcode":"security","name":"Security"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"}],"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}]},{"discussionID":67256,"type":"question","name":"Adding resources cost","excerpt":"Hi all, I'm fairly new to smartsheet, and i wanted to know how do i use the \"bill rate\", ca I change it? How can I access it? I think this is the solution for my issue which is i want to add the costs to my resources and I couldn't find the best practices for that. Would love to hear any tips and recommendation. Thanks,…","categoryID":321,"dateInserted":"2020-04-08T16:59:15+00:00","dateUpdated":null,"dateLastComment":"2020-04-12T19:36:21+00:00","insertUserID":120325,"insertUser":{"userID":120325,"name":"Noga Ginzburg","url":"https:\/\/community.smartsheet.com\/profile\/Noga%20Ginzburg","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-04-12T20:16:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":73566,"lastUser":{"userID":73566,"name":"rgochee","url":"https:\/\/community.smartsheet.com\/profile\/rgochee","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2020-04-13T16:11:02+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":683,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/67256\/adding-resources-cost","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67256\/adding-resources-cost","format":"rich","groupID":null,"statusID":2,"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":null,"acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}]},{"discussionID":67149,"type":"question","name":"Incremental Budget Forecasting based on Monthly Due Date Percentages","excerpt":"In excel, we have two sheets: Sheet 1 - A percentage breakdown per country based on historical data for each Month prior or after the Due Date month. Zero = Month Due Date. -1 = the Month prior to the Due Date Month, etc. Sheet 2 - For Country, Due Date and Projected Total Spend, we calculate (via formulas) the Current…","categoryID":322,"dateInserted":"2020-04-03T19:08:47+00:00","dateUpdated":"2020-04-06T06:50:24+00:00","dateLastComment":"2020-04-09T11:45:50+00:00","insertUserID":43226,"insertUser":{"userID":43226,"name":"EmilyH","url":"https:\/\/community.smartsheet.com\/profile\/EmilyH","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!pXjaqewWrKY!ZtHMGd3RfX4!-O-QDMYhg72","dateLastActive":"2022-11-30T14:31:37+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"updateUserID":91566,"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-25T17:46:09+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":17,"countViews":663,"score":null,"hot":17,"url":"https:\/\/community.smartsheet.com\/discussion\/67149\/incremental-budget-forecasting-based-on-monthly-due-date-percentages","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/67149\/incremental-budget-forecasting-based-on-monthly-due-date-percentages","format":"rich","groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/609\/742MBQ9P5DZ4.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Screen Shots.JPG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2020-04-09T10:56:45+00:00","dateAnswered":"2020-04-08T17:54:42+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":254,"urlcode":"formulas","name":"Formulas"},{"tagID":319,"urlcode":"functionality","name":"functionality"},{"tagID":440,"urlcode":"project-management","name":"Project Management"}],"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}]},{"discussionID":62966,"type":"question","name":"changing email address in contact list (web formular)","excerpt":"Hi everybody, I use a contact list in a web formular. Unfortunately, it is not possible to write a new email address into the drop down list which is not yet included in the list. It simply disappears after writing it + Enter. Is there a way to do so? greetings Joerg ","categoryID":322,"dateInserted":"2019-11-15T02:41:58+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-02-26T16:10:33+00:00","insertUserID":107466,"insertUser":{"userID":107466,"name":"Joerg Schmidt","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Joerg%20Schmidt","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!ZFNXGZNkaTw!pKDXaa84r-Y!9WSWmAUhJKN","dateLastActive":"2023-05-04T06:23:52+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":91566,"lastUser":{"userID":91566,"name":"Genevieve P.","title":"Community Manager","url":"https:\/\/community.smartsheet.com\/profile\/Genevieve%20P.","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/KHY4Y67W0VRX\/nF76D5N9MFB28.png","dateLastActive":"2023-08-25T20:36:29+00:00","banned":0,"punished":0,"private":false,"label":"Employee Admin"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":83,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/62966\/changing-email-address-in-contact-list-web-formular","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/62966\/changing-email-address-in-contact-list-web-formular","format":"Html","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2020-03-03T13:58:13+00:00","dateAnswered":"2019-11-18T09:18:04+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":322,"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions","allowedDiscussionTypes":[]},"tags":[{"tagID":220,"urlcode":"hospitality","name":"Hospitality"},{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":247,"urlcode":"contacts","name":"Contacts"},{"tagID":254,"urlcode":"formulas","name":"Formulas"}],"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}]},{"discussionID":54476,"type":"discussion","name":"Automated update request not working","excerpt":"Hi, We are creating an automated workflow that requests an update thru a specific mail and it does not seem to work. Automated approval workflows work perfectly but update requests don't send the appropriate mail requested (eventhough in the sheet you can see that there's an update requested). Can you please help? Thanks…","categoryID":321,"dateInserted":"2019-08-06T14:49:58+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2020-02-02T14:58:53+00:00","insertUserID":99046,"insertUser":{"userID":99046,"name":"karen.michel99046","url":"https:\/\/community.smartsheet.com\/profile\/karen.michel99046","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-08-06T14:46:23+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-08-26T17:06:33+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":835,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/54476\/automated-update-request-not-working","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/54476\/automated-update-request-not-working","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/2019-08\/30\/67\/30676ec8571fefaffe7347009ac1b47a.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"update request.jpg"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":218,"urlcode":"construction","name":"Construction"},{"tagID":238,"urlcode":"finance","name":"Finance"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"}],"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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">