-
Replicating multiple worksheets in Excel
We use an xls file to manage our monthly staff rota. I want to transfer this to SS but we use multiple worksheets, one for each month, ie one for Jan, one for Feb etc. What is the best practice for replicating this functionality on SS please? Thanks. Michael
-
Remove the Logo From Your Account
I was trying to figure out a way to remove the logo from my Smartsheet, account. I did not want the default logo, and I did not want to use my company logo, since there is no way to control the location of the logo. There may be a better way to do this, but here is what i did: * 1) On the Account dropdown menu, go to…
-
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…
