-
Tabs No Longer Showing
Sometime last week I noticed my view in Smartsheet (using Chrome) no longer has the tabs at the top of all of the current open sheets. How can I get this view back? It was much more efficient than the pinning option we have now. Also, the recently reviewed Smartsheets would be great if it actually filled up that column but…
-
Reference a column in another sheet
Hello - My company is new to smartsheets but it has ALREADY made a huge difference for us. I'm playing with functions that reference other sheets and I have a very specific question - I'd like to sum all of a column IF two conditions are met: the dates match and the payment type is the same. The formula I'm working looks…
-
Filter by Color
Is it possible to filter a sheet by color (either font color or cell color)?
-
Reporting from multiple sheets into a single resulted row
Is there a way to run a report that looks at 2-n sheets that uses a common column (primary key like), like a Row ID, to import the data from several sheets into a single row of the report?
-
Allow access to specific items only
Hi all, I am creating a set of sheets. * Main sheet: gathers all the tickets about issues raised from the field (customer). Ticket (row) will be added using a customized form. tickets are coming from several types of users.* Engineers that belongs to the company. * Engineers that are external and belongs to the customers.…
-
Remove automatic hyperlink on rich text dashboard widget
I've created a rich text dashboard widget and the information that I am typing into the widget is automatically creating a hyperlink which I do not want. Any suggestions on how to remove the auto hyperlink?
-
Filtering/selecting columns?
Any way to filter/select only specific columns to view? I know you can hide columns and maybe that's all, but in a sheet with 50 columns that is super cumbersome. Would be great to have an option to filter or otherwise select to narrow the column view.
-
Lock or pin from Editing and Deleting. Even by Admin
Hello, I'd like to pin or lock or freeze a column from being edited as that information is going to archiving and doesn't need to be edited for the next 10 years. But I don't want to delete it accidentally, or edit the column contents. It seems like the lock only prevents Editors from changing the content. How do I make it…
-
% Complete in a Filtered Schedule
Hello! I am new to smartsheet and am having an issue. We have a schedule where we have several different project type options. Depending on the project type, the project types that are not applicable to that project are filtered out and hidden. So there are several hidden tasks in each of our schedules. The problem I am…
-
Protecting Special column when importing
Hi, I've got a sheet in which I import from an Excel spreadsheet data on a daily base. In that sheet I have a column (RYG balls) with a formula to calculate overdue estimates. But every time that I import the new data, that column is crushed. I even added it at the far end beyond the imported data parameter. Is there a way…
