Sheets

0) this produced #unparseable. My ultimate goal is to have a dashboard that will display a pie chart with total number of leads per person. Thanks for any help!","categoryID":322,"dateInserted":"2023-03-09T14:00:08+00:00","dateUpdated":null,"dateLastComment":"2023-03-09T19:44:14+00:00","insertUserID":159203,"insertUser":{"userID":159203,"name":"Ddyer","url":"https:\/\/community.smartsheet.com\/profile\/Ddyer","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxa99iDchMxhzP7JtJAXp0TdSi_szbSnpCWuh3qB=s96-c","dateLastActive":"2023-03-09T19:42:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":159203,"lastUser":{"userID":159203,"name":"Ddyer","url":"https:\/\/community.smartsheet.com\/profile\/Ddyer","photoUrl":"https:\/\/lh3.googleusercontent.com\/a\/AGNmyxa99iDchMxhzP7JtJAXp0TdSi_szbSnpCWuh3qB=s96-c","dateLastActive":"2023-03-09T19:42:49+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":107,"score":null,"hot":3356762662,"url":"https:\/\/community.smartsheet.com\/discussion\/102359\/i-want-to-count-the-number-of-times-a-contact-appears-in-a-column-how-do-i-do-that","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102359\/i-want-to-count-the-number-of-times-a-contact-appears-in-a-column-how-do-i-do-that","format":"Rich","groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-03-09T19:42:47+00:00","dateAnswered":"2023-03-09T14:13:54+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":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":91674,"type":"question","name":"Form Entries are Negative","excerpt":"Weekly I have about 15 sites completing the form linked below. The issue, I have roughly two random users each week entering a negative one into the form. One user who is pretty savvy indicated the form is defaulting to a negative one. https:\/\/app.smartsheet.com\/b\/form\/ebc99e53148a4a479060b3d695321030 I have NOT setup any…","categoryID":321,"dateInserted":"2022-06-01T06:07:08+00:00","dateUpdated":"2022-06-01T06:16:15+00:00","dateLastComment":"2023-03-09T19:32:23+00:00","insertUserID":119518,"insertUser":{"userID":119518,"name":"Amy Arnold","url":"https:\/\/community.smartsheet.com\/profile\/Amy%20Arnold","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!GpdD39UP27w!B_9DgcE2Wfo!f-wVNvq4uBf","dateLastActive":"2023-01-29T09:06:53+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭"},"updateUserID":119518,"lastUserID":150107,"lastUser":{"userID":150107,"name":"Chris K","url":"https:\/\/community.smartsheet.com\/profile\/Chris%20K","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!zYvqc6ot0_M!nOEr3_YRCfs!3WulPBZJhWw","dateLastActive":"2023-04-10T16:28:18+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":4,"countViews":342,"score":null,"hot":3332456371,"url":"https:\/\/community.smartsheet.com\/discussion\/91674\/form-entries-are-negative","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/91674\/form-entries-are-negative","format":"Rich","groupID":null,"statusID":2,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/KF7GABIS117O\/smartsheet-2-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Smartsheet 2.PNG"},"attributes":{"question":{"status":"answered","dateAccepted":null,"dateAnswered":"2022-06-02T22:16:58+00:00","acceptedAnswers":[]}},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"tags":[{"tagID":204,"urlcode":"Forms","name":"Forms"},{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":334,"urlcode":"automations","name":"Automations"},{"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":102385,"type":"idea","name":"Please add a Wildcard Function","excerpt":"Smartsheet is missing the ability to use a wildcard (*) in it's functions. This is a valuable tool and would be incredibly helpful, please add this functionality.","categoryID":349,"dateInserted":"2023-03-09T17:49:02+00:00","dateUpdated":"2023-03-09T18:00:36+00:00","dateLastComment":"2023-03-09T17:49:02+00:00","insertUserID":137019,"insertUser":{"userID":137019,"name":"Samuel Mueller","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Mueller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B9G8B70WXQWC\/nKTI46EH9WQOM.jpg","dateLastActive":"2023-06-09T17:45:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"updateUserID":91566,"lastUserID":137019,"lastUser":{"userID":137019,"name":"Samuel Mueller","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Samuel%20Mueller","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/B9G8B70WXQWC\/nKTI46EH9WQOM.jpg","dateLastActive":"2023-06-09T17:45:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":0,"countViews":39,"score":1,"hot":1678384442,"url":"https:\/\/community.smartsheet.com\/discussion\/102385\/please-add-a-wildcard-function","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/102385\/please-add-a-wildcard-function","format":"Rich","groupID":null,"statusID":10000,"attributes":{"idea":{"statusNotes":null,"statusID":10000,"status":{"name":"Idea Submitted","state":"open"},"type":"up"}},"bookmarked":false,"unread":false,"category":{"categoryID":349,"name":"Smartsheet Product Feedback & Ideas","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-product-feedback-%26-ideas","allowedDiscussionTypes":[]},"tags":[{"tagID":219,"urlcode":"Sheets","name":"Sheets"},{"tagID":254,"urlcode":"Formulas","name":"Formulas"},{"tagID":363,"urlcode":"Idea Submitted","name":"Idea Submitted"}],"reactions":[{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}]}],"title":null,"subtitle":null,"description":null,"viewAllUrl":null,"isMainContent":true,"noCheckboxes":false}">

Check Another Sheet for Value across Multiple Columns
In Sheet 2, I am looking to search Sheet 1 for an instance of a value, that could be in one of four columns. Sheet 1 COLUMN A | COLUMN B | COLUMN C | COLUMN D | COLUMN E | ABS 123 | March | 26444 | | 43454 | ABS 456 | June | 87834 | 45003 | | ABS 789 | August | | | | ABS 000 | October | | | 36543 | There are four order…
Count the number of times a text value appears in a single cell (or alternatively, split the cell)
嗨内容社区,我有一个column of data with cells that contain text values that I need to count. For example, the cell in one of these columns may contain something like: "ABC123 - TEXT TEXT TEXT ABC008 - TEXT TEXT TEXT" The two lines of "ABC" text are separated by a carriage return. I'm trying to count how many…
Dynamic Drop-Down
Does anyone know if the options in a drop-down can be linked to a table? I have a sheet that users can pick a "provider" from a drop down list. That provider is associated with a vlookup that helps to populate other columns in that sheet. However, the "provider" list is dynamic and changes when a new provider is added to…
Can someone assist with looking at children rows vs selecting exact cells?
Hello! Each time I change the sorting of this sheet, my formulas are changed. The formula is technically correct, the issue is that I am referencing exact cells, so when sorting it throws it off. =SUMIF([Open By Year]38:[Open By Year]43, @cell < TODAY(), [Total Units Signed For]38:[Total Units Signed For]43) - [# Open]@row…
Within a SUMIFS formular, I'm trying to add on to a count if a contact appears in a multi-contact or
How can I add a number of days to a date column in the same sheet?
Hi! I currently have a column that is supposed to add 14 days to another date column in the same sheet. The formula I'm using is: =["Date Column"] + 14 However, what I keep getting is "Apr 21, 2020 3:10 PM14". Both columns are date columns. Thanks so much in advance!
Many columns on sheet - not all appear as options in a report?
Happy faux Friday! I'm working with a very large (about 30 columns) data sheet in Smartsheet. I'd envisioned it as the one source of truth to feed multiple reports. The problem is the latest report I'm trying to build, the 5 columns that I need to appear and provide data, are not showing up in the columns from which I can…
I want to count the number of times a contact appears in a column, how do I do that?
So, I started with =COUNTIF(Name:Name), FIND("John Smith", @cell) > 0) this produced #unparseable. My ultimate goal is to have a dashboard that will display a pie chart with total number of leads per person. Thanks for any help!
Form Entries are Negative
Weekly I have about 15 sites completing the form linked below. The issue, I have roughly two random users each week entering a negative one into the form. One user who is pretty savvy indicated the form is defaulting to a negative one. https://app.smartsheet.com/b/form/ebc99e53148a4a479060b3d695321030 I have NOT setup any…
Please add a Wildcard Function
Smartsheet is missing the ability to use a wildcard (*) in it's functions. This is a valuable tool and would be incredibly helpful, please add this functionality.

Sheets

Discussion List