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
Workspace Notifications - not individual sheets
I dont believe this is possible and if you not i'd like to request this as a feature. Some of my workspaces can have up to 28 or 30 sheets in them, all related to the same project. As the owner i would like to be notified of any changes within these 28 -30 sheets, but dont want to have to repeat the process of setting up…
cant add or hide column
I have the majority of functions greyed out. Screenshot attached. Any suggestions?
Max number of rows?
What is the maximum number of rows for a sheet? I'm getting errors when uploading but I don't know what the limit is. Also, are there any workarounds to the limit? Thank you.
Want sum calculation in report - Formulas in reports?
Does anyone know if there is a way to add a formula for a report? What I want to do is sum the values of a column for all rows returned for a report and to add some sort of highlight when the sum exceed a certain value. Specifically, if the amount of hours for a list of tasks for day assigned to a given person exceeds…
exact match formula in Smartsheet
Hi, has anyone had any luck using an exact match formula is Smartsheet? I have two columns that have text in them. I want the 3rd column to tell me if column 1 and 2 are an exact match or not. I know how to do it in excel =Exact(A1:B1) but not sure how to set up in Smartsheet. Also, can you apply a formula to an entire…
Pull Down Menu Options from Common Source/Sheet
All, I am using Smartsheets to track time, and have run into an issue that I have to believe there is a workaround for. We need our associates to track their time with specific job and client IDs. This can be done by making the time tracking entries show as a pull down menu of codes. But, when we get new jobs or clients,…
Order value based on price breaks
Hi, I have ~30 products each with four price breaks and I need to determine the value for each order (a single product type is listed per row) based on the ordered quantity and its associated price break. The really clunky method I have used so far is two main nested IF formulas and additional columns:- The first main…
Preparing the Process
Hi to everyone I would like share with others users my questions about peparing the sheet for organize the jobs of the company where I work to see what are you guys think about this subject. I have to organize and follow every job of the company. The company have a lot of jobs (many hundreds) and in each jobs have about 15…
Drop down list data from column in another sheet
Hello Users, I am very new to SS and was wondering how I might go about achieving the ability to link a cells data to an entire column in another sheet. For example, I have a "Current Jobs" sheet and a "Distributors" sheet. When I enter a new job in Current Jobs, the Distributor field in current jobs must only contain…
Web Form Check Box Option
Hi All! I am creating a web form for Volunteer Applications for our organization. I need to include a field which allows the applicant to choose from a list of helpful skills and hobbies which they have. I want to allow them to choose as many as are applicable but the only option I see is a single choice dropdown menu. Is…