-
Copy Sharing when duplicating (Save as New) sheet.
We create (copy) a new sheet each month, keeping all the formatting but not the attachments and comments and cell lnks. Is there a way to duplicate the sharing as well. The sheets are in the "Sheets" folder. I have created a Workspace with the sharing, but when I move or copy the sheet to the "Sheets" folder, the sharing…
-
Report Builder Gantt Chart is off
I've been playing around with report builder, to create a summary page of all my sheets. I have a check box I use to filter the lines I want on the report, which are typically the first/top line, which is the entire project. The Gantt view in each sheet is correct, but in the report, every line has the gannt shifted by one…
-
What determines the country (currency) of a sheet
Prior to the latest release currency columns displayed as $0,000.00. Now it displays as CA$0,000.00 which adds clutter. All our computers have US as regional Settings. If I change my personal seettings to Canada the CA goes away but the date format is d-m-y and can't be changed to m-d-y, so changing the settings is not an…
-
numbering child rows
I have a sheet I've been using for a while. I just added a column and set it up to auto number. All the rows increased sequentially, e.g. 1, 2, 3 etc. The child rows, and their child rows continued in orer, in otherwords the child of parent row #1 was #2. I'd like the child of Row #1, to be 1.1 or something like that. Be…
-
Image-Hyperlink
Wondering if there is a way to make an image as a hyperlink (Click on image). I have tested the option of adding image in cell, and also just add hyperlink with text, but I do not see way to actual make the image as a hyperlink. Thanks for any input.
-
Multiply total project cost by percentage to get sale price
Hello! This is my first post, and I know the answer is simple, but here it goes: I want to take a total project cost column and multiply it by a percentage that is inputted into another call, and have the answer populate an "Extended Price" column. Eventually I want to be able to add subtotals and do the same thing, but…
-
Suggested feature: Starred Sheets for easy reference
Problem: with a lot of sheets, it can sometimes be daunting to quickly find the on you're looking for. Proposed solution: what if SS used something like Google's "star" feature? Here's a quick mock-up just to get the juices flowing (potentially).
-
Can you only indent to 1 level or is there a way to allow further indents?
Can you only indent to 1 level or is there a way to allow further indents?
-
Live Data Connector
I have a Smartsheet linked to Excel (using the Live Data Connector). When I refresh the data in Excel all data refreshes. Is there any way to limit what appears after refreshing? I only want to show what is new and/or what has been changed in Smartsheet?
-
Error When Saving Smartsheet
I have been searching the existing posts for something like my current experience, to no avail. This morning, I have been having trouble with my program management sheet. All of our current projects roll up to this sheet, and this sheet goes to my VP. It is large, but has always been large. I haven't changed anything…
