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 2017 Posts

100% then red, if due date within 5 days of today and % complete <> 100% then yellow, if due date outside of 5 days from today % complete > 1 and < 100% then green, if % complete is 0 and…","categoryID":319,"dateInserted":"2017-02-16T13:00:36+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-20T14:29:37+00:00","insertUserID":10940,"insertUser":{"userID":10940,"name":"Patrick Galvin","url":"https:\/\/community.smartsheet.com\/profile\/Patrick%20Galvin","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2018-04-16T16:37:50+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":41966,"lastUser":{"userID":41966,"name":"Tony Barthelemy","url":"https:\/\/community.smartsheet.com\/profile\/Tony%20Barthelemy","photoUrl":"https:\/\/lh3.googleusercontent.com\/-XdUIqdMkCWA\/AAAAAAAAAAI\/AAAAAAAAAAA\/4252rscbv5M\/photo.jpg","dateLastActive":"2021-02-21T20:22:40+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":20,"countViews":452,"score":null,"hot":20,"url":"https:\/\/community.smartsheet.com\/discussion\/7333\/does-anyone-have-the-formula-syntax-to-control-the-ryg-and-gray-symbols-on-a-sheet","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/7333\/does-anyone-have-the-formula-syntax-to-control-the-ryg-and-gray-symbols-on-a-sheet","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"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":7349,"type":"discussion","name":"Linking Comments","excerpt":"When you link a row to another sheet will comments carry over? If not, is there a way to do this? Thank you, Crystal Lehto","categoryID":319,"dateInserted":"2017-02-17T10:30:41+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-16T00:20:10+00:00","insertUserID":8916,"insertUser":{"userID":8916,"name":"Crystal Lehto","url":"https:\/\/community.smartsheet.com\/profile\/Crystal%20Lehto","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-04-05T08:13:27+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":96276,"lastUser":{"userID":96276,"name":"Rob Leach","url":"https:\/\/community.smartsheet.com\/profile\/Rob%20Leach","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2019-07-16T00:19:03+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":7,"countViews":338,"score":null,"hot":7,"url":"https:\/\/community.smartsheet.com\/discussion\/7349\/linking-comments","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/7349\/linking-comments","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"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":8001,"type":"discussion","name":"Scheduled export of sheets","excerpt":"Hi there. I'd love to see a feature implemented whereby a scheduled export of sheets could be set up. I'm thinking in particular about project plans but this could apply to any sheets. We have a team subscription but we don't need to set weekly backups of entire workspaces, but I would love to be able to set certain sheets…","categoryID":319,"dateInserted":"2017-04-11T05:52:51+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-12T15:16:13+00:00","insertUserID":11167,"insertUser":{"userID":11167,"name":"Rob Cook","url":"https:\/\/community.smartsheet.com\/profile\/Rob%20Cook","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-04-18T04:09:00+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-10T13:58:10+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":13,"countViews":3243,"score":null,"hot":13,"url":"https:\/\/community.smartsheet.com\/discussion\/8001\/scheduled-export-of-sheets","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/8001\/scheduled-export-of-sheets","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":265,"urlcode":"Reports","name":"Reports"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":300,"urlcode":"Email Notifications","name":"Email Notifications"},{"tagID":439,"urlcode":"gantt-view","name":"Gantt View"},{"tagID":440,"urlcode":"project-management","name":"Project Management"},{"tagID":445,"urlcode":"importing-and-exporting","name":"Importing and Exporting"}],"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":7012,"type":"discussion","name":"Nested IF Statements","excerpt":"My nested IF statment =IF([% Complete]3 = 0, \"Red\", IF([% Complete]3 = 100, \"Green\", \"Yellow\")) is setting the symbol to \"Yellow\" when clearly the statment requires that IF([% Complete]3 = 100 (thie evaluates to true), \"Green\". What am I missing? ","categoryID":319,"dateInserted":"2017-01-20T02:54:11+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-10T19:08:13+00:00","insertUserID":10252,"insertUser":{"userID":10252,"name":"Sergio Seplovich","url":"https:\/\/community.smartsheet.com\/profile\/Sergio%20Seplovich","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-01-11T15:29:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":7492,"lastUser":{"userID":7492,"name":"Benjamin Walker","url":"https:\/\/community.smartsheet.com\/profile\/Benjamin%20Walker","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/pictures\/1b\/63\/n1b63b1a090b9e3d83ed5a30ad0e05b54.jpg","dateLastActive":"2020-01-27T20:40:59+00:00","banned":0,"punished":0,"private":false,"label":"Employee"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":5,"countViews":4331,"score":null,"hot":5,"url":"https:\/\/community.smartsheet.com\/discussion\/7012\/nested-if-statements","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/7012\/nested-if-statements","format":"Html","groupID":null,"statusID":0,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_attachment\/files\/73\/07\/730777a2c7a2d785c6a96634c80b008a.PNG","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Nested_IF.PNG"},"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"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":13276,"type":"discussion","name":"Dynamic drop down list","excerpt":"Is it possible to link a drop down list to a query from another sheet column. For example It would be great to be able to have users select items from a list of the top ten sold items. This list would update as sale demand changes. or being able to only select items of a certain type based off another column.","categoryID":319,"dateInserted":"2017-09-05T13:42:51+00:00","dateUpdated":"2019-12-09T08:04:32+00:00","dateLastComment":"2019-07-10T10:03:38+00:00","insertUserID":22636,"insertUser":{"userID":22636,"name":"Jeremy Whitehead","url":"https:\/\/community.smartsheet.com\/profile\/Jeremy%20Whitehead","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2017-09-05T13:29:25+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":95521,"lastUser":{"userID":95521,"name":"Sam Harwart","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Sam%20Harwart","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/drupal_profile\/files\/2019-07\/20\/55\/n2055f412b30c3cc5f7db1204f1262e1f.png","dateLastActive":"2021-08-20T14:45:26+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":true,"sink":false,"countComments":15,"countViews":1178,"score":2,"hot":17,"url":"https:\/\/community.smartsheet.com\/discussion\/13276\/dynamic-drop-down-list","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/13276\/dynamic-drop-down-list","format":"Html","groupID":null,"statusID":0,"attributes":{},"bookmarked":false,"unread":false,"category":{"categoryID":319,"name":"Archived 2017 Posts","url":"https:\/\/community.smartsheet.com\/categories\/c2017","allowedDiscussionTypes":["discussion","question"]},"tags":[{"tagID":207,"urlcode":"Sales","name":"Sales"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":283,"urlcode":"Enhancement Request","name":"Enhancement Request"},{"tagID":446,"urlcode":"update-requests","name":"Update Requests"},{"tagID":472,"urlcode":"cell-linking","name":"Cell linking"}],"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}">

Creating a Sum for Filtered Rows
I have a Sheet which contains a complete list of all invoices, which Customer they are for, the Invoice Total and an Invoice Paid column which would show the balance of the Invoice. I have created a number of Filters for all of my Customers, so that I can filter straight to one Customer and see their outstanding balance.…
How to force a sheet to fully recalculate via the API
Hi there API Developer community, I wish to use the API to force a sheet to recalculate. Currently, we use a report that shows just the first row of every one of our 50 or so project sheets and then we manually copy a new value into a column on that report that we have put aside for the purpose. So, once a value like…
Parent row inheriting status from its children
Hi. I have a number of children rows for each parent. The child rows each have a "Status" column which is using the red, yellow, green icons. I'd like the parent row to inherit the worst case summation of the child rows. E.g. if the child rows are red, green, and green, the parent row would show red. E.g. if the child row…
How to stop due date reminders once task has been completed
HI- We use Smartsheet for tasks that need to be completed by several people. We currenlty have reminders set up for due dates (both 5 days before due date and past due date). Is there a way to NOT send the reminder if the task has been completed/the 'Date Completed' field has a date in it?
Edit Contact - Include Phone Number
Hi Community - I'm looking for a way to associate phone numbers with contacts (in addition to their email address). I would like the ability to hover over a contact's name (in an Assigned To column, for example) and see not only their email address, but also their phone number and perhaps additional information such as…
Does anyone have the formula syntax to control the RYG and Gray symbols on a sheet
Does anyone have the formula syntax for this.... to control the RYG and Gray symbols on a sheet? if due date < today and % complete <> 100% then red, if due date within 5 days of today and % complete <> 100% then yellow, if due date outside of 5 days from today % complete > 1 and < 100% then green, if % complete is 0 and…
Linking Comments
When you link a row to another sheet will comments carry over? If not, is there a way to do this? Thank you, Crystal Lehto
Scheduled export of sheets
Hi there. I'd love to see a feature implemented whereby a scheduled export of sheets could be set up. I'm thinking in particular about project plans but this could apply to any sheets. We have a team subscription but we don't need to set weekly backups of entire workspaces, but I would love to be able to set certain sheets…
Nested IF Statements
My nested IF statment =IF([% Complete]3 = 0, "Red", IF([% Complete]3 = 100, "Green", "Yellow")) is setting the symbol to "Yellow" when clearly the statment requires that IF([% Complete]3 = 100 (thie evaluates to true), "Green". What am I missing?
Dynamic drop down list
Is it possible to link a drop down list to a query from another sheet column. For example It would be great to be able to have users select items from a list of the top ten sold items. This list would update as sale demand changes. or being able to only select items of a certain type based off another column.

Popular Tags

If you are using a multi-select dropdown, you will want to include a HAS function like so:<\/p>

=COUNTIFS({New RT - Priority}, [Column2]$28, {New RT - Platform}, HAS(@cell, \"CASI\")<\/strong>)<\/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":107379,"type":"question","name":"How to find duplicates in the document name column?","excerpt":"There are more than 700 documents and I want to find duplicate rows, I am new to Smartsheet.","snippet":"There are more than 700 documents and I want to find duplicate rows, I am new to Smartsheet.","categoryID":322,"dateInserted":"2023-07-10T12:57:20+00:00","dateUpdated":"2023-07-10T13:23:10+00:00","dateLastComment":"2023-07-10T13:05:27+00:00","insertUserID":163271,"insertUser":{"userID":163271,"name":"Umar Farooq","title":"MR","url":"https:\/\/community.smartsheet.com\/profile\/Umar%20Farooq","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-07-10T13:22:57+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":163271,"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-07-10T13:05:35+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":1,"countViews":14,"score":null,"hot":3377988767,"url":"https:\/\/community.smartsheet.com\/discussion\/107379\/how-to-find-duplicates-in-the-document-name-column","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107379\/how-to-find-duplicates-in-the-document-name-column","format":"Rich","lastPost":{"discussionID":107379,"commentID":384335,"name":"Re: How to find duplicates in the document name column?","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384335#Comment_384335","dateInserted":"2023-07-10T13:05:27+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-07-10T13:05:35+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-10T13:23:23+00:00","dateAnswered":"2023-07-10T13:05:27+00:00","acceptedAnswers":[{"commentID":384335,"body":"

Try this in a checkbox or flag type column:<\/p>

=IF(COUNTIFS([Document Name]:[Document Name], @cell = [Document Name]@row)> 1, 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":107354,"type":"question","name":"Same Level Multiple Approvals","excerpt":"Is there a way to sent out a request that contains multiple approvals? There is a situation where we have a record that may contain anywhere from 1 to 3 approvals. All approvers have the same authority. To tally the approvals I would create a separate column that evaluates the decisions of either all approved, all declined…","snippet":"Is there a way to sent out a request that contains multiple approvals? There is a situation where we have a record that may contain anywhere from 1 to 3 approvals. All approvers…","categoryID":321,"dateInserted":"2023-07-07T20:23:37+00:00","dateUpdated":"2023-07-07T20:24:42+00:00","dateLastComment":"2023-07-10T13:36:37+00:00","insertUserID":131545,"insertUser":{"userID":131545,"name":"Paul Reeves","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Reeves","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/2B7GJH1T1ULO\/n6MUQUILM6FJP.jpg","dateLastActive":"2023-07-10T13:36:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":131545,"lastUserID":131545,"lastUser":{"userID":131545,"name":"Paul Reeves","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Reeves","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/2B7GJH1T1ULO\/n6MUQUILM6FJP.jpg","dateLastActive":"2023-07-10T13:36:58+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":3,"countViews":49,"score":null,"hot":3377759414,"url":"https:\/\/community.smartsheet.com\/discussion\/107354\/same-level-multiple-approvals","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107354\/same-level-multiple-approvals","format":"Rich","tagIDs":[334,448],"lastPost":{"discussionID":107354,"commentID":384346,"name":"Re: Same Level Multiple Approvals","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/384346#Comment_384346","dateInserted":"2023-07-10T13:36:37+00:00","insertUserID":131545,"insertUser":{"userID":131545,"name":"Paul Reeves","url":"https:\/\/community.smartsheet.com\/profile\/Paul%20Reeves","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/2B7GJH1T1ULO\/n6MUQUILM6FJP.jpg","dateLastActive":"2023-07-10T13:36:58+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-10T13:22:25+00:00","dateAnswered":"2023-07-08T05:06:14+00:00","acceptedAnswers":[{"commentID":384259,"body":"

Hello @Paul Reeves<\/a> <\/p>

Yes, fortunately there is a way to create multiple approvals on the same level under the automation request tab where you can add more people from your org to approve\/decline any decision. Here is the simplest way to do it -<\/p>

using the automation workflow, send approval requests to multiple people or to contacts or to everyone shared to the sheet and store their responses in separate columns using the advanced feature of this workflow. <\/p>

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

<\/p>
Hope this helps!<\/p>
Cheers,<\/p>
Ipshita<\/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"},{"tagID":448,"urlcode":"workflows-in-smartsheet","name":"Workflows in Smartsheet"}]}],"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":[]}">

Welcome to the Smartsheet Forum Archives

Archived 2017 Posts

Discussion List

Categories

Popular Tags