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" …
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, whic…
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 seetting…
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…
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 m…
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…
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…
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 w…
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 r…