-
Creating report to show Parent Row based off Child Row
I am trying to design a report to list to our outside salesman. I need to filter it based on contractor names, but those are child rows to the parent row which is the job name. So in the picture, I would want the criteria to be "ROMANOFF", so I could pull all jobs they are on, which in this case, would be 12th Avenue…
-
Any ideas
Hi Guys, I have two columns one for pay rate(dollar amount) and one for work comp classification (3 options: carpenter, painter or clerical). I also have a legend that has 5 different rates based on different criteria. The criteria is as follows carpenter >35, carpenter<35, painting>26, painting<26, and Clerical. I'm…
-
database
Hello, Smartsheet team! I work for a medical equipment sales company which is intereted in create a database of all our client’s equipment. We want to sort all this information out in order to eliminate paperwork. We need to apply different filters which allow us to manage the record of all this equipment. Currently, if we…
-
Form results to email alert
Hi, is it possible to convert the results of a form to a pdf document for emailing? Currently when the form is submitted, an Alert action sends an email of the results to our helpdesk program but there is no formatting and it is hard to read. Thanks
-
Same Multiselect twice.
Is there a way that the a selection in a Multi select dropdown can be selected more than once? When you select the one of the options, it gets removed for the list. I'm wondering if there's a work around so that someone could pick the same thing twice, as a way of managing quantity. The drop down I'm working with is pretty…
-
Export to Excel from Dynamic View
Is there a way to export to excel from dynamic view?
-
Update on: Edit a reports without access to the underlying Smartsheet.
Is there any update on this function or a new workaround? Please see here: https://community.smartsheet.com/discussion/5916/editing-reports-without-having-access-to-the-underlying-sheet or https://community.smartsheet.com/discussion/17606/allowing-people-to-access-reports-without-having-access-to-the-main-sheet This…
-
Creating Index for Unique Values
I am trying to create a formula that can be converted to a column formula but am having issues. I referred to https://community.smartsheet.com/discussion/54816/extracting-a-list-of-unique-values-from-a-list-on-another-sheet to come up with the formula to use, however it uses absolute references, which can't be made into…
-
Update Request to multiple users
Hello, I have a sheet where, through automation, an update request is sent out to our purchasing team to log in a PO number and PDF copy of the PO. This UR is sent out to two people BUT the issue is that once one of them logs in and completes the UR, the other person still views the "Update Request" in their tasks. Is…
-
Is there an expiry date for the update request?
Some of my team members could not update the request I sent through Smartsheet. Most of these issues are reported on the links which are older than 30 days
