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 th…
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-…
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 colu…
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 criteri…
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!
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 ac…
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?
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 n…
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 …
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.