-
Excel Formula Error
Hi All, I've referenced the forums for help and thought someone might help me with the "unparseable" error I am getting. We are trying to do complex formulas: =COUNT(IF(FREQUENCY([Listing Key]2:[Listing Key]20)>0,1)))) The "[Listing Key]2:[Listing Key]20" reflect the chosen cells to crunch the formula. Attached is a…
-
Report Frustrations from SmartSheet
I have been using Smartsheet now for about 2 months. While I love it for so many reasons, I am frustrated too. I love being able to run the reports, there are so many great filters......why don't they just allow a function to add totals to the reports. Hence, when management asks me to report the sales numbers based on…
-
Web form populates parent/child relationship through category
Hello, was hoping to get some help on an issue i am having .. we have an inventory control sheet .. we would like to use a web form(s) to not only take out something of the inventory but to also add something to the inventory. I added a Category column and that is reflected in a dropdown list that matches all of the…
-
Adding Task name to exported comments
Hello, when I do an export to PDF I get the comments on a separate page, which is all fine. However the reference on that page to the gannt chart is the Row Number. Is there a way of adding the Task Name to this comment page? The reason is that it can be a bit confusing to scroll up and down to reference the row and…
-
Creating a Temple for Router Configrations
I have an existing sheet with a lot of information in it. I would like to create a template to populate based of the information in my existing sheet. Then I would like to be able to print or export the information to create a router or switch configuration template. Sounds easy enough but have never done this and would to…
-
S-curves
Hi everyone, Someone knows if it's possible to make S-curves with Smartsheet to track project progress? If it's not, have you found any convenient way to make S-curves out of your Smartsheet data? I mean without copying manually the data to an excel or MS Project file. Best, Jason
-
Copying column headings and layout from one sheet to a new one
Good morning all We've had a message pop up stating that we've reached our quota for one of the sheets we're using. I'd like to be able to quickly replicate the sheet again on another new sheet, along with the form we use, colour scheme, and current layout. Is this possible?
-
Can a Smartsheet form submitted auto-populate PDF then triggers DocuSign
Hi, I am trying to deploy a reimbursement system for my office. Once a person submits a form via smartsheet, I need to have a PDF pre-filled with all of the info including the ones that will be linked to other cells. Once the PDF is prefilled, I will need it to go thru DocuSign for signature. Once the user signs I will…
-
Dropdown Assigning
I have a program that imports data from an excel sheet. The data contains names of a project manager and a project ID. I have a dropdown list containing all the PMs and their emails, and what I was wondering was when I populate the PM column with the PMs name, is there any way to attach the corresponding email of the PM so…
-
Data -> Exported Form
Hello, I am relatively new to SmartSheets but I am looking to place a form we have now into smartsheets to collect the data there. However our Executive Team likes the look of the original form... Is there a way to export data in a way other then in a grid/ excel looking chart? Id like to customize it and have it run only…
