-
Enhancement Request: relative addressing for cell linking in sheets, reports and sights
It would be great to be able to use relative addressing in cell linking between sheets and links in reports and sights instead of the fixed linking as currently implemented in Smartsheet. Why? We use Smartsheet for project management and have a set up a standard workspace which contains set of sheets/reports and sights…
-
Dates Don't Act As Dates if Linked from Another Smartsheet
In short... if I pull a date from another sheet using "Link from Cell in Another Sheet", I can't do formulas off that date. I've verfied that the columns are formatted as dates. [Opening Date]1 is linked from another Smartsheet. I want to add 180 days to the [Opening Date]1. [Opening Date]1 = 08/22/82 Here's what the…
-
Resource Planner with Location & Dates
Dear All, has anyone created a resource planner that shows day by day location such as onsite, offsite, vacation, public holiday etc.? I would like for two columns with the resource name and the resource role and then the rest of the columns should be the calendar with the column showing the day and date for the month. An…
-
Formula to Average Child Progress Bars
I'm hoping to find a formula I can use to automatically fill out the parent row's progress bar based on the child rows. The result would look something like this, just not sure if this is possible. * * Section 1 is 50% because: Sub-task 1 + Sub-task 2 + Subtask 3 = 150 then / 3 tasks = 50% progress bar Section 2 is 75%…
-
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!
-
Publish Links - Private mode only
I love the option that allows you to publish a link and display in html. However, I cringe at the thought of this being visible to anyone. We do not want our competitors or unauthorised users to peek at our projects. Is there a way to control who gets to see this published page? Thanks, Peter.
-
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…
-
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!
-
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…
-
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…
