-
How to index + match with multiple criteria ?
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 different collumns(part 1 - 3) and when those match they have to give me the corresponding Time. This…
-
Cross-Sheet Reference Limit
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!
-
FILTER A REPORT ON MOBILE APPLICATION
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 sheets. On mobile, for the same report, I don't find the way to do it. Do I miss something…
-
Question: Can you identify the worksheet behind a form?
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?
-
Search for Hyperlink
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 workaround for this? Perhaps there is a way to create a hidden column and a formula of…
-
Table of contents in a large sheet; use of forms
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 needs to scroll down to find the right category which is time consuming. Two questions…
-
Criteria need for a "is one of" filter
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.
-
If, Then Formula
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 on the 15th of each month, so the formula would need to cover a 45 day period. I added…
-
Search, If & Input
I've been having some difficulty trying to solve this one: * I have a master sheet where forms are inputted * For each row there are two columns I need to set up in an IF for, and one where I need a value inputted from another sheet * I imagine it like this: IF column 1@row = {other sheet} …This reference should search an…
-
Use browser find with Ctrl-F as default.
Is there a way to set the default behavior of typing Ctrl-F to use the Browser search function? I am already aware of both Ctrl-F and Ctrl-Shift-F behavior in smartsheet. I simply prefer using Chrome's built in search. It's faster and had nice obvious highlighting. I can work around by clicking the three dots and clicking…