-
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…
-
Values not appearing in linked Excel table
I have a report that pulls from several Smartsheets. When I run the report in Smartsheet, I see all my values appearing. However when I refresh the linked report in Excel, not all the values appear. My values are text/number so there is room for numbers as well as "N/A" -which we manually enter. I have another, very…