-
Why are columns not printing in the width that I've set them on the report?
We have a lot of people complaining about the size of the reports when they print. We would like the content on one page, and when we shrink the column width in the report it still stretches out when printed making the font very small. Is there a way to maximize the page similar to excel when you pick the "fit columns on…
-
How to automatically update text every week?
Hello, So I have two columns: "Date Week Ending" that lists the last Saturday of each week and "Reference" that lists an X value. I want to have the X value appear for the PREVIOUS week ending date when my current week starts. For example, if today is 9/9 then I want the "X" value to appear for the week ending date of 9/7.…
-
Meeting Management - Implementation of Template Set
Hello All, Has anyone implemented the Meeting Management template set who would be willing to share what works and what could be improved? We are looking at moving our minutes into Smartsheet (obviously), and I would like to understand a bit more. The "Getting Started Guide" for the Meeting Management template set is a bit…
-
Merged: Trigger a Data Shuttle Action via Automation Workflow
This discussion has been merged.
-
Sum(Collect Calculation giving #Circular Reference Error
=SUM(COLLECT({Forecast Amount}, {Customer}, $Label@row, {Sales Stage}, Qualification$1)) That is the calculation I am using bring forecast sales based on Customer and Sales Stage into a metrics collection sheet. I am going out to the Sales Pipeline sheet for the information, two (2) sheet prints attached for reference.…
-
I want to be able to hide my formulas from being viewed when you hover over the cell.
I have a sheet that has a lot of complex formulas and is used (and edited) by many users. When the users are referencing the sheet, the formulas show up and get in the way of reviewing the data. Is there a way I can hide the formulas from popping up when others are using this sheet to edit? All of the columns with the…
-
API Updating Row Format
I was trying to find some documentation on the format string and came across this forum. https://community.smartsheet.com/discussion/13111/update-row-background-with-api I'm trying to update the format of an entire row ( mainly just trying to update the background color of an existing row ). In the forum above it says to…
-
Sync all Projects with a Template
Would be great to have any changes made to a template to also be changed in all sheets that were made with that template. Would make updating projects much easier as currently you have to go through each individual project if you need to make a change like adding a new column.
-
'Save as New' to Multiple Different Locations at Once
Currently if you need to copy a file to multiple different locations you have to do each location individually. Would be great if you could select multiple locations at once to copy the file to.
-
Form timer
Suggestion to have the option to limit the time a form is accessed, from the time the user begins/enters the form. If the form was not submitted prior to the time limit, the form would close and capture answers up to that point. We want to use this feature for interview assessments sent out to candidates. It allows us to…