Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for October 2016
Discussion List
Saving Smart Sheets in storage
I hate having all of these smart sheet tabs. Is there a way to export them to a smart sheet format in another directory? I dont want to save to excel or any other format. I just want to hide my smart sheets off my tabs. Thanx!
Issues linking cells
I have created a dashboard linking cells to cells in other sheets. It has been working great. However, I am now running into issues when linking new cells: * 1. The End date is not populated. * 2. The %Complete in the dashboard does not roll up the the group. If I try to link the <End Date> cell it says, "You cannot create…
Report Widget Details
Hi Everyone, When i open to select a report, it shows messgae as " you can only select the reports which you are an admin". I have no idea about this. I am using trial for 30 days pack. Can anyone please provide help regarding this... Best Regards viji
Request: Formatting and Design of Web Forms
Hi, would be SO handy to have decent formatting options on a web form. i.e. text size, colour, bold, italics centre right margin etc etc etc... I find it hard with black/grey and a few other colours to make things stand out (such as important notes or messages) We look forward to an improved web form
Contacts and Web forms
Hi Everyone, I am relatively new to smartsheets and there are two things I have been trying to work out adn for the life of me can not find the information to show how its done. The first is having a field aut populate based on picking a contact e.g Contact name = Gary Bee then the next cell should auto popolate with Gary…
How can I calculate the percentage a resource is allocated to each project?
How can I calculate the number of days or allocation percentage a resource is assigned to a project? What I'm trying to understand is the percentage a resource is allocated to a project so I can track the total in a master project list. For example, if a resource is assigned to 3 projects and they are aloocated 25% per…
Reference a Cell in another Sheet in a Formula?
Howdy! I'd like to count the number of occurances of a specific value in a column on another sheet. It works great this way, but within the same sheet: =COUNTIF([Column4]17:[Column4]26, "Red") Is there a way to select a range of cells on another sheet and return (in this case) the number of them that are Red? Thanks!
Workspace Tabs
I've seen a lot of requests for more functionality around the tabs feature and I have a suggestion of my own. How about a "Workspace" tab that when clicked on offers a drop-down list of all of the sheets in the workspace? I'm thinking the tab bar could be a mix of "Sheet" tabs and "Workspace" tabs. Second suggestion, it…
Attaching an item to a column or specific cell?
Is there a way to attach a file (Word, Excel, etc) to a column or a specific cell? I know how to attach an item to a sheet or row, but need it on a column or cell. TIA!
Reference Row Number?
I'm building a task management sheet that prioritizes tasks by their order on the sheet. A formula calculates lead time of a task based on its current position in the list. Is there a way to dynamically reference the row number of a task? The easiest way would be a function that references the row number (since those…
