-
Sorting
I have a question about Sorting and what may possibly be a future enhancement. Is it possible that when I add a new row and hit Save, it will know my Sort preferences and move that row to the respective place?
-
Share reports without sharing entire underlying sheet
Hello, I would like to understand the best process to, once a month, update a sheet with data from 2 partners. then I would like to share just that partners data with them for viewing and possilby updating. is the best way a report on top of the sheet with a fitler? i tired this and it seemed that they could click through…
-
SUMIF YEAR
Hi, I would like to do: SUMIF(YEAR(A1:A50), 2016, B1:B50) The above doesn't work. How else can I construct this formula? thanks, Column A is a date column Column B is a currency/number column
-
Drop down menu
Can I use a drop down menu to auto fill line item onto another sheet? or can I have another sheet have a rule that says "if drop down menu reads dept.#2 fill in information drom another sheet"?
-
Feature Request: Timeline within Smartsheet
One feature that MS Project had that I've had a hard time working around is a timeline feature that is part of the application. I understand that SS integrates with Office Timeline, but I have to pay for this, manually manipulate this, and I have to recreate a timeline each time deliverables change on my plans. We have a…
-
Webform vs Request Form
I really like the Webform feature. It's made things easier with coordination and data entry. Could I also upvote a feature for Request Form (as an extra step)? It would nice if the submitted Webform goes directly to the sheet administrator first to approve before it goes to a sheet directly. Not because it's been submitted…
-
Grouping multiple columns
Hi, I have a budget sheet that hierarchically grouped by teritotry. There are columns that captures the category and subcategory. I am able to see the total amount of each teritory individually or the whole region using the hierarchy function. If I would like to see the total for the Category or subcategory, how do I go…
-
Master sheets - why sheets and not reports?
New to SS. Setting up many project sheets and then want the high level info pulled together onto a master sheet. Videos I've watched say to create a master sheet and link data in from project sheets. Project management webinar I watched has a company that designs/fabricates/installs 10,000 signs per year (complicated…
-
Can't Add Filter
I have multiple sheets created and only see the option to add a filter to one sheet. Are there any restrictions to have filters? I have a basic acount, maybe this is it? Do I need to create any specific content that woud enable the filter?
-
Apply Format to individual words including hyperlinks
Hi, We really need to be able to format individual words with in a cell, instead of the format effecting the entire cell. For example: Here is some text within a cell and I want to highlight a particular word and NOT all the words in the cell. The same applies to adding a hyperlink to an external URL. Today it hyperlinks…
