-
Hi All,
I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
Formulas and Functions63
KDub618
-
Hi Guys
We are doing an all-sheets search via the API and cannot figure out why, on one of the sheets, it is not including certain rows:
(Image)
The search is:
https://api.smartsheet.com/2.0/search?scopes=cellData&query="97*"…
API & Developers26
Paul de Villiers
-
Folks,
I want to be able to search a number of non-contiguous cells in a row to find a certain value, then return the contents of the cell immediately to the left of the cell that contains the value.
I know there has to be a way to do this…
Using Smartsheet21
Dennis Wierzbicki
-
I understand I can likely do this with a very, very long VLOOKUP or IF/THEN formula in every cell, but I'm dealing with over a hundred items and that will be unwieldy.
Situation:
I would like to have a form where someone selects one op…
Formulas and Functions3342
Dajah
-
Dataset:
(Image) Required Output:
(Image) I am trying to extract data from the rows which have its first column starting with particular contents. As I have shown in the attached example, I wish to get data of columns A, C, and D if the co…
Formulas and Functions72
Himanshu Agarwal
-
It would be helpful to be able to filter a search to only look at a specific column in a sheet. Sometimes I know what column the info I am looking for is in but I am only able to search the whole sheet where there might be more than one in…
Using Smartsheet11
CDecker
-
Good afternoon,
Would it be possible to create a product that allows users to do a live search on sheets and even possibly aggregate data from multiple sheets to produce given search results. I have already built this through a customized…
Formulas and Functions23
Anthony Verhoeven
-
When using webforms and submitter puts in their name, if their name is already in contacts it doesn't match to contacts name. So you end up with a new name entry the same as an already existing name in your contacts column. Could they be…
Archived 2015 Posts286
Mark Bonham
-
Hi everyone!
Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified"
Here's …
Formulas and Functions83
lisarae723
-
Hi,
I'm trying to reference contact info from one sheet and have it show up in another as I type. I want the second sheet to search a column as I type and match the contact name if it exists. Does smartsheet have a vlookup or somethi…
Formulas and Functions32
Michael A.
-
I wish, I wish upon a sheet that these will someday be a reality...if some of these are already posted, I apologize... Product team - most, if not all, of these were sent to Scott Willeke verbally or via e-mail so he could lend more contex…
Using Smartsheet223
@CollabMeganPMP
-
Hi, I thought I saw something flash up awhile ago about a way to build a site/page or something like that that can be used to keep stuff on per project. Almost like a social media thing.
I cannot remember the name of that to look it up so…
Using Smartsheet23
rmcbride108121
-
Hello All,
I have been a huge fan of the "recently opened" Navigation tab and have about 30 sheets pinned. I do use various sheets at various times, however, and would like to rearrange the order of these sheets as well as be a…
Using Smartsheet24
Iz
-
I am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month:
=COUNTIFS({Tippa JC Status}, ="…
Formulas and Functions96
grant53396
-
I have update requests set for each employee's annual review. I would like to change one bit of text in the preformatted email. Is there a way to do this? Specifically, the line reads:
Contact Mary Beth or Jesse.
I would like to remove …
Using Smartsheet34
MB
-
I have 2 columns (Stage) and (Courses) Courses is a multi dropdown, stage is a single drop down.
I want to count how many people are invited to Fundamentals 1 vs how many have completed or certified in a rollup sheet. I am either gett…
Using Smartsheet49
TdeGroh
-
Hello,
Are we able to lock comments on rows or sheets do that they stay to the top?
Using Smartsheet12
nmazardw
-
We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and th…
Formulas and Functions396
Jess Merritt
-
Can anyone tell me how I can filter to show only sheet level attachments (i.e. attachments that are not attached to a specific row but instead are attached to a sheet)? At the moment I have to manually trawl through all attachments in the …
Using Smartsheet12
JohnM
-
I explain, I need to create an expiration date from a drop-down menu where the different types of payments of my clients are informed. Example, if a customer's account is "up to date" it means that the due date will be the issue …
Formulas and Functions187
Gerardo_Clarke
-
Hi All,
I have an issue of a filter not working that previously worked fine.
The filter looks for cells in a column formatted for text/numbers.
Here's an example of the data in the column:
NLOND_3104-1
NLOND_3709-2
-2
-1
-2
NLO…
Formulas and Functions65
Mark Welch
-
My apologies if this has already been covered, but I didn't see anything specific to this subject when searching.
I have a Excel sheet that has 45,000 + rows. The data in the rows are filled by 2 columns - United States Zip Code's and cit…
Formulas and Functions332
Jack C
-
Hi!
I'm trying to figure out how to do the following excel formula in Smartsheet, but I am having trouble with it. Can I get some help please ?
Basically what I need to do is match 3 different criteria (lookup 1 -3) with 3 differen…
Archived 2017 Posts1313
Yannick Decock
-
Concerning the current limit of 25,000 total cross-sheet references per sheet - is there an easy way to determine how many are currently being used on any given sheet?
Thanks!
Formulas and Functions63
JBLS_
-
Hi,
I am interrested to know if we can filter on report on mobile apps.
I explain, on computer we have the possibility to choose filters by Where, Who, What, and/or. It is really helpful to have an activity follow up linked to many sheet…
Using Smartsheet62
WISZ
-
The subject really says it all. I know I can go into a worksheet and identify the forms created for it, but can I do the reverse or do I simply have to check every worksheet until I find it?
Using Smartsheet14
cesbrandt
-
Is there any way to search a sheet for a URL, if it is included in a hyperlink? The URL does not appear on the sheet, the text for the hyperlink does instead. I tried searching, given a URL, and its not finding anything on my sheets.
Any …
Using Smartsheet34
aschneiderheinze74206
-
hi,
I use one large sheet to manage many different legal tasks across my team (1,000 rows currently). The sheet is divided to many sub sections/categories, main tasks, sub tasks etc. Wanting to add a new main task to a category, the user…
Using Smartsheet124
Tomer
-
When making a filter using the condition "is one of", how do you separate the options in the criteria? I have tried commas, semicolons, quotation marks and parentheses. None are working.
(Image)
Using Smartsheet23
Jasper Stewart
-
Hi everyone,
I've searched through the community but couldn't find the right solution.
I need to feed specific sales metrics into a dashboard but want it to update, according to the Today column. I receive the previous months information…
Formulas and Functions43
lisarae723
