Sign in to join the conversation:
Has anyone created a report that was able to pull data from both sheets and forms that are attached to sheets?
This was the message back from support. This cannot be done at this time.
Hello,
Thanks for contacting Smartsheet Support. We don't currently have the functionality to create a report that contains data from rows from sheets and data from an attached form to a sheet, but I've let our Product team know about your request. We appreciate your input!
Hey Barbara,
Appreciate you linking the response from support. I guess I wanted to make sure I understood your question correctly. You could use a report to grab data from 2 different sheets and populate this report with the corresponding form entries. The form is the mechanism to input data into a single row in a sheet so I am unclear what you would be pulling other than row data which is populated by the form. Do you mean pulling data from an attachment in that row item?
Thanks!
Hello, I have a general question. looking to move a SHEET from one workspace to another. That sheet has a FORM and Workflow Alerts set up. Will that disrupt my workflow and inactivate the form link? Just want to confirm what I need to do to ensure the SHEET and workflow alerts don't break. User is the same. Second question…
I have a worksheet where every line is one of four "types". Once each line is worked and completed I move those lines to an "Archive" sheet based on their "Type". Currently I have four separate automations that move a single "type" to it's respective worksheet. The way I see current automation possibilities only allows me…
I want to show on a report a calculation (results from formula) based on entries from the report viewer, but I do not want the report viewer to be able to edit the cell with the formula. It appears that if I lock the column, the calculation does not show in the report. What are my options to show locked column data on a…
