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 2015 Posts
Archives for May 2015
Discussion List
Find the value of the next month based on today.
How do I add 1 month to today? I don't want to add 30 days or anything, I just want to get to the next month and I have to be able to cross years. so if today is 2/1/2015 I want to find March is next; if today is 12/31/2015 I want to find Jan is next. Do I need a lookup or is there a date function that would get me this?
Reminders for web form submission
Does anyone know how to set up a reminder for certain people shared on a sheet to submit their webform by a certain day? I have set up a sheet with a web form attached for employees to submit their weekly timesheets. The timesheet should be submitted by each Monday morning. I want an alert to go out to everyone on the…
Webforms
Travis, I would like to request that Smartsheets gives us the ability to print a webform after it has been submitted. I know if you are the one filling out and submitting the webform you can request an email copy which is great. But if I'm the one managing the smartsheet that the info populates into I do not have that…
How do i create a multiple line column heading?
With Excel, we can enter a column name, and create a line break with the Alt-Enter key combination. How can we get the same effect (one or more lines in the column names) with Smartsheet?
Calculating sums using IF statements
I have two columns of data, one is a class of data in text, the other is a numerical value. I would like to calculate a subtotal of the value of the numerical value based on class. Is there an easy way to do this? I can pull a report based on the class, but it would be nice to have a running total of all classes and their…
Day of the week formulas
How do I schedule repeating appointments on a specific day of the week; Ex: Every Mon at 10:00 First Tue of the Month at 09:00 I did not see the day of the week variable or formula. Thanks Alan Guggenheim
Auto assign helpdesk queries
Hi, I have set up a webform to collate helpdesk queries. Every query is one of 6 types (one of the fields on the webform is a drop down to select the type of query. I would like to automatically assign one of four people to handle each query based on which of the 6 types the query is regarding (there is a mapping of type…
Drop Down Lists
I am new to smart sheets and way behind my fellow community members level. I have a database spreadsheet for tracking new product development. Question: can you incorporate a drop down list into a smartsheet. Appreciate your advice and apologies for the simplicity of the question. Reagrds, Mark Quillinan
Different branding/logo for each web form
I work for an events company and we use smart sheets mainly for public facing web forms. We have multiple events at once and like to promote the event name and branding instead of our company name. Is there a way to have a different brand and logo for each smart sheet/web form? Also can we use a photo as the background…
Printing a sheet with gnatt chart view
Our Gnatt time display is set to weeks but when I print the sheet the Gnatt time display is displaying Quarters. Is there a way to ensure that the printed sheet will have the gnatt timeline in weeks?