-
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…
-
Build Report for Group of Users
We have a number of User Groups.. some users overlap groups, as many of us wear a few hats. I'd like to build reports that run through the "ZZZ Workgroup" and look for lines that are assigned to anyone in "Group AAA." Perhaps also reports that pertain to "Group BBB" and "Group CCC" Yes, I could select each person in the…
