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 2017 Posts
Archives for June 2017
Discussion List
Reporting more than one item
I think there is something easy I'm missing with this. I was testing to see if what I wanted would work before adding a bunch of sheets. I took 2 sheets, I wanted to report Sales and boxes for each project in the same report. When I only enter one of the 2 items in the "What" the report will generate and include that one…
merge cells
Hello everyone, Is there any way to merge cells in Smartsheet? Thank you in advance!
Two questions on Published sheets
Couple questions: - if a change happens to a sheet that I've published using a link will it refresh with new data or do I have to re-publish every time a change happens? - does the URL change after each publishing? I ask because I don't want to have to be constantly updating the url ie. I can simply provide a shortcut and…
Announcements
Hi! I'm looking for some way to make an announcement on a sheet/report/sight when it is opened to let my users know about new functionality/requirements/processes instead of sending a separate email letting them know about the changes... Any ideas/suggestions for this? I need something bold and eye-catching. Preferably…
Count the number of projects in a folder
Our team is looking for a way to count the number of projects of three distinct types. I have them located within three different folders. I do not want to have to use cell linking. A user should be able to create a new project without having to open a summary sheet and create a new cell link. If I could use a formula in a…
Moving a sheet
We are new to smartsheets. We can not move a sheet from Sheets to Workspace. Does anyone know why this is happening. I can move some sheets but not one. I am sure it is how it was created or some setting but I have looked and nothing stands out.
Renaming a Report through the API
Hello, Is there a way to rename a report through the API? Thanks, Nathan
Formula help
I'm trying to create a single sheet that has multiple audits from 4 facilities. I am finding problems in trying to have smartsheet count the amount of cycles in the audit. The information is being input through the web forms so new rows are being created constantly, and the information needs to run through the sort filter…
Create Gantt from End to Start
Hello! As a project manager, I often find myself needing to make timelines starting with my end date. However, I have only been able to make Gantt charts in Smarsheet (with dependencies) that I can change the very first start date and then the durations, but I can't work backwards or change start dates to meet my needs! Is…
Printing Issues with Embedded Smartsheet
We have a Smartsheet embedded in a SharePoint page on our intranet. It is published using the 'Edit by Anyone' option. Our authorized users have no problem updating the Smartsheet, but when we try to print (by clicking on the printer icon on the toolbar), we get an error that says "The sheet that you are attempting to…