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.

Archived 2016 Posts

Discussion List

Delivery: Schedule to send later or on a recurring basis feature. Now, when I navigate to the message at Sent to > (my leader) > Edit Recurrence \/ Delete these selections are greyed out. Not moments ago I was able to open…","categoryID":318,"dateInserted":"2016-01-11T10:05:12+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-13T10:10:43+00:00","insertUserID":2723,"insertUser":{"userID":2723,"name":"Jaye Casciano","url":"https:\/\/community.smartsheet.com\/profile\/Jaye%20Casciano","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/OB4IJYEZR1XW\/nU83D7QKKE5D0.jpg","dateLastActive":"2023-07-11T17:01:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":2723,"lastUser":{"userID":2723,"name":"Jaye Casciano","url":"https:\/\/community.smartsheet.com\/profile\/Jaye%20Casciano","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/OB4IJYEZR1XW\/nU83D7QKKE5D0.jpg","dateLastActive":"2023-07-11T17:01:57+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":175,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/3903\/cant-edit-recurrence-in-scheduled-attachment-deliveries","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3903\/cant-edit-recurrence-in-scheduled-attachment-deliveries","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":245,"urlcode":"Sharing","name":"Sharing and Collaboration"},{"tagID":268,"urlcode":"Attachments","name":"Attachments"}],"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":3914,"type":"discussion","name":"request","excerpt":"smartsheet is and how it Uaj month in what seems to Sir please Helf","categoryID":318,"dateInserted":"2016-01-13T02:05:45+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-13T09:52:02+00:00","insertUserID":5022,"insertUser":{"userID":5022,"name":"mukesh kumar","url":"https:\/\/community.smartsheet.com\/profile\/mukesh%20kumar","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-01-13T01:59:22+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":1,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/3914\/request","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3914\/request","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":249,"urlcode":"Education","name":"Education"}],"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":3837,"type":"discussion","name":"Two finish date","excerpt":"Hello, I dont find way how I can make that in Gantt view show two dates - planned finish date and actual finish date - but I need it show in one row?","categoryID":318,"dateInserted":"2016-01-04T04:35:13+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-13T09:41:59+00:00","insertUserID":1986,"insertUser":{"userID":1986,"name":"fxx87","url":"https:\/\/community.smartsheet.com\/profile\/fxx87","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-01-04T04:33:47+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4905,"lastUser":{"userID":4905,"name":"Tim McCarthy","url":"https:\/\/community.smartsheet.com\/profile\/Tim%20McCarthy","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-06-02T15:59:51+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":3,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/3837\/two-finish-date","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3837\/two-finish-date","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[],"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":3904,"type":"discussion","name":"Building a report or form that allows the user to query for a row?","excerpt":"We have been thinking of creative ways to allow users to manage just what is their responsibility without the added risk of someone fat fingering a change to a row that they do not own and the question came up if there was functionality to pull up data for a row similar to a DB query? We have users submit requests to our…","categoryID":318,"dateInserted":"2016-01-11T10:08:56+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-13T09:14:15+00:00","insertUserID":4522,"insertUser":{"userID":4522,"name":"Evan Meyers","url":"https:\/\/community.smartsheet.com\/profile\/Evan%20Meyers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-01-11T09:08:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4522,"lastUser":{"userID":4522,"name":"Evan Meyers","url":"https:\/\/community.smartsheet.com\/profile\/Evan%20Meyers","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2016-01-11T09:08:38+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":2060,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/3904\/building-a-report-or-form-that-allows-the-user-to-query-for-a-row","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3904\/building-a-report-or-form-that-allows-the-user-to-query-for-a-row","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"tagID":344,"urlcode":"it-operations","name":"IT & Operations"},{"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}]},{"discussionID":3897,"type":"discussion","name":"How can I import an Access Database to Smartsheets?","excerpt":"Pretty sure that this is not possible directly. Is there a multiple step way? For example, exporting database into something like MS Project of some Google sheet? I would export to Excel but I would like to keep the attachments that Access database has. Thanks.","categoryID":318,"dateInserted":"2016-01-11T06:22:56+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-12T16:49:52+00:00","insertUserID":4969,"insertUser":{"userID":4969,"name":"Neuroger","url":"https:\/\/community.smartsheet.com\/profile\/Neuroger","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2022-10-05T13:22:38+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":256,"lastUser":{"userID":256,"name":"SashaR","url":"https:\/\/community.smartsheet.com\/profile\/SashaR","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2015-09-03T19:11:56+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":721,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/3897\/how-can-i-import-an-access-database-to-smartsheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3897\/how-can-i-import-an-access-database-to-smartsheets","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":268,"urlcode":"Attachments","name":"Attachments"},{"tagID":277,"urlcode":"Integrations","name":"Integrations"}],"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":3896,"type":"discussion","name":"How can I view history of attachment downloading?","excerpt":"When I shared sheet to collaborators to use attachment on sheet, I would like to know who download the attached file from sheet. ","categoryID":318,"dateInserted":"2016-01-11T03:32:05+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-12T16:47:16+00:00","insertUserID":4780,"insertUser":{"userID":4780,"name":"Rueparade Sriwatcharangkun","url":"https:\/\/community.smartsheet.com\/profile\/Rueparade%20Sriwatcharangkun","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-03-09T01:35:36+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":177,"lastUser":{"userID":177,"name":"Travis","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Travis","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/9b\/30\/n9b30d18a803dd0ccefe2f8f2d8765390.jpg","dateLastActive":"2020-01-21T20:47:54+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":1,"countViews":158,"score":null,"hot":1,"url":"https:\/\/community.smartsheet.com\/discussion\/3896\/how-can-i-view-history-of-attachment-downloading","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3896\/how-can-i-view-history-of-attachment-downloading","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":268,"urlcode":"Attachments","name":"Attachments"}],"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":3910,"type":"discussion","name":"Download Sheet Access Report is blank","excerpt":"Good morning, I'm needing to review who has access to the various sheets and I've tried to download this report in Google (blank), Firefox (it won't let me even access the Account area) and IE11 (blank report). Help? Blessings, Loann","categoryID":318,"dateInserted":"2016-01-12T11:07:02+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-12T14:44:19+00:00","insertUserID":254,"insertUser":{"userID":254,"name":"Loann McGee","title":"Broadcast Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/Loann%20McGee","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/G3A1KBYOQBWU\/nBYWBBSSF9DWC.jpg","dateLastActive":"2023-07-06T22:04:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":null,"lastUserID":254,"lastUser":{"userID":254,"name":"Loann McGee","title":"Broadcast Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/Loann%20McGee","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/G3A1KBYOQBWU\/nBYWBBSSF9DWC.jpg","dateLastActive":"2023-07-06T22:04:54+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":2,"countViews":146,"score":null,"hot":2,"url":"https:\/\/community.smartsheet.com\/discussion\/3910\/download-sheet-access-report-is-blank","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3910\/download-sheet-access-report-is-blank","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":209,"urlcode":"Media & Entertainment","name":"Media & Entertainment"},{"tagID":216,"urlcode":"Non-profit","name":"Non-profit"},{"tagID":261,"urlcode":"Account and User Management","name":"Account and User Management"},{"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":3889,"type":"discussion","name":"Switch Users in Smartsheet","excerpt":"As i am involved in a number of charity projects and two businesses, I have several smartsheet log-ins under different email addresses. I would be very pleased if there was a function to 'switch users' rather than having to log out and back in to each one. Better still if all accounts could be opened simultaneously ... Can…","categoryID":318,"dateInserted":"2016-01-08T23:53:25+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-12T13:39:14+00:00","insertUserID":357,"insertUser":{"userID":357,"name":"gb82","url":"https:\/\/community.smartsheet.com\/profile\/gb82","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!8lFEd_Vr-Xo!nPjFn6lBhqQ!1RcftNgU8bM","dateLastActive":"2023-02-10T23:29:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":null,"lastUserID":357,"lastUser":{"userID":357,"name":"gb82","url":"https:\/\/community.smartsheet.com\/profile\/gb82","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!!8lFEd_Vr-Xo!nPjFn6lBhqQ!1RcftNgU8bM","dateLastActive":"2023-02-10T23:29:06+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":8,"countViews":107,"score":null,"hot":8,"url":"https:\/\/community.smartsheet.com\/discussion\/3889\/switch-users-in-smartsheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3889\/switch-users-in-smartsheet","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":261,"urlcode":"Account and User Management","name":"Account and User 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":3886,"type":"discussion","name":"Web form options","excerpt":"I have created a new web form and I'm wondering if its possible to give my user the ability to select more than one response for the same question when using the radio buttons function? ","categoryID":318,"dateInserted":"2016-01-08T15:09:23+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2016-01-12T11:29:32+00:00","insertUserID":4946,"insertUser":{"userID":4946,"name":"Cathy Clark Thomas","url":"https:\/\/community.smartsheet.com\/profile\/Cathy%20Clark%20Thomas","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-03-13T15:49:55+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":4374,"lastUser":{"userID":4374,"name":"J. Craig Williams","title":"","url":"https:\/\/community.smartsheet.com\/profile\/J.%20Craig%20Williams","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/74\/da\/n74da5fe4ff9c5b38c13d6409a3c883a3.jpg","dateLastActive":"2023-05-13T18:07:11+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":3,"countViews":753,"score":null,"hot":3,"url":"https:\/\/community.smartsheet.com\/discussion\/3886\/web-form-options","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/3886\/web-form-options","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":318,"name":"Archived 2016 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2016","allowedDiscussionTypes":[]},"tags":[{"tagID":261,"urlcode":"Account and User Management","name":"Account and User 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}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">
I would just click there on row two and indent it once so that it is a child of row 1.<\/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":107587,"type":"question","name":"Help with formula","excerpt":"I need some help with a formula. See sheet summary. I just need help with the first one \"move in items open\" and I can apply the same formula structure to the rest. I want to count the amount of Warranty phase column if that says \"move in items\" and the status is Not started or In progress\" and have that be 1 number. Any…","snippet":"I need some help with a formula. See sheet summary. I just need help with the first one \"move in items open\" and I can apply the same formula structure to the rest. I want to…","categoryID":322,"dateInserted":"2023-07-13T20:10:58+00:00","dateUpdated":null,"dateLastComment":"2023-07-13T20:32:18+00:00","insertUserID":144391,"insertUser":{"userID":144391,"name":"Jon Barto","url":"https:\/\/community.smartsheet.com\/profile\/Jon%20Barto","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-13T21:51:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":144391,"lastUser":{"userID":144391,"name":"Jon Barto","url":"https:\/\/community.smartsheet.com\/profile\/Jon%20Barto","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-13T21:51:45+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":18,"score":null,"hot":3378560596,"url":"https:\/\/community.smartsheet.com\/discussion\/107587\/help-with-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107587\/help-with-formula","format":"Rich","lastPost":{"discussionID":107587,"commentID":385132,"name":"Re: Help with formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385132#Comment_385132","dateInserted":"2023-07-13T20:32:18+00:00","insertUserID":144391,"insertUser":{"userID":144391,"name":"Jon Barto","url":"https:\/\/community.smartsheet.com\/profile\/Jon%20Barto","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-13T21:51:45+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/TQ7LFUFZ13RR\/warranty.jpg","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"warranty.jpg"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-13T20:47:26+00:00","dateAnswered":"2023-07-13T20:19:40+00:00","acceptedAnswers":[{"commentID":385121,"body":"

Give this a try:<\/p>

=COUNTIFS([Warranty Phase]:[Warranty Phase], \"Move in Items\", [Status]:[Status], OR(@cell = \"In Progress\", @cell = \"Not Started\"))<\/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":107571,"type":"question","name":"Yellow Code Not Working in Formula","excerpt":"I have the underlying code in a sheet to look at specific items in a row. The Red and Green Code is working as expected by my yellow code is not. I am assuming it has to do with the way I have sestup the today function I have tried both =TODAY(2) and >=TODAY(2) niether seems to work. IF(AND([Due Date]@row = TODAY(2),…","snippet":"I have the underlying code in a sheet to look at specific items in a row. The Red and Green Code is working as expected by my yellow code is not. I am assuming it has to do with…","categoryID":322,"dateInserted":"2023-07-13T17:28:22+00:00","dateUpdated":null,"dateLastComment":"2023-07-13T21:58:08+00:00","insertUserID":162256,"insertUser":{"userID":162256,"name":"delaurellc","title":"Senior Consultant","url":"https:\/\/community.smartsheet.com\/profile\/delaurellc","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtf4bLRCxTWbiShmV4wW7Ah1awahmzvkEsk_gLoMMj4VnA=s96-c","dateLastActive":"2023-07-13T22:10:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":162256,"lastUser":{"userID":162256,"name":"delaurellc","title":"Senior Consultant","url":"https:\/\/community.smartsheet.com\/profile\/delaurellc","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtf4bLRCxTWbiShmV4wW7Ah1awahmzvkEsk_gLoMMj4VnA=s96-c","dateLastActive":"2023-07-13T22:10:03+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":7,"countViews":30,"score":null,"hot":3378558990,"url":"https:\/\/community.smartsheet.com\/discussion\/107571\/yellow-code-not-working-in-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107571\/yellow-code-not-working-in-formula","format":"Rich","lastPost":{"discussionID":107571,"commentID":385170,"name":"Re: Yellow Code Not Working in Formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/385170#Comment_385170","dateInserted":"2023-07-13T21:58:08+00:00","insertUserID":162256,"insertUser":{"userID":162256,"name":"delaurellc","title":"Senior Consultant","url":"https:\/\/community.smartsheet.com\/profile\/delaurellc","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AAcHTtf4bLRCxTWbiShmV4wW7Ah1awahmzvkEsk_gLoMMj4VnA=s96-c","dateLastActive":"2023-07-13T22:10:03+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":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-07-13T21:57:50+00:00","dateAnswered":"2023-07-13T20:00:01+00:00","acceptedAnswers":[{"commentID":385104,"body":"

Try this:<\/p>

=IF(Status@row <> \"Complete\", IF([Due Date]@row< TODAY(), \"Red\", IF([Due Date]@row>= TODAY(3), \"Green\", \"Yellow\"))<\/p>


<\/p>

The main issue with your formula is that you are saying to only flag yellow when the due date is equal to TODAY(2) instead of less than or equal to.<\/p>"},{"commentID":385144,"body":"

There are a number of ways to do this. The most secure way would actually mean a restructure and an OR statement:<\/p>

=IF(Status@row <> \"Complete\", IF(OR([Due Date]@row = \"\", [Due Date]@row.= TODAY(3)), \"Green\", IF([Due Date]@row< TODAY(), \"Red\", \"Yellow\"))<\/p>


<\/p>

I moved the Green argument to be first because sometimes Smartsheet will read a blank cell as being less than a non-blank cell. If we had left it in the original order, this would have meant it would flag as true on the red argument when the due date was blank.<\/p>


<\/p>

Of course there are a number of other ways to do it, but this would be my personally preferred method.<\/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":[]}],"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":[]}">

Trending Posts