-
ATTACHMENTS FOR EACH QUESTION IN THE FORM
Hello to all I hope you can help me with this issue, I need that in a survey each answer can attach a description and evidence (photos) but it only allows me to upload a single file in a question. Will there be any solution? a single file upload. Will there be any solution?
-
Automation - Referencing and Changing Values Between Sheets
Hi, I have build a functional, if not exceptionally efficient, UAT process in which individual tests for a product feed up via cell links to a "Master Product Test Sheet". In this sheet the "Approver" monitors the testing and when a test is flagged as completed and automation "Approval Request" kicks off asking the…
-
What is the best way to collect resources time using Smartsheet Form?
Using forms, I am trying to collect the time my resources spend each week across multiple project codes. I am looking for total hours spent by project during a time period. I would want to collect the following information User Name, Start Period, End Period, Project Code, Hours I can do this when it is one project code,…
-
Dashboards on rows
Hello Everyone, I am trying to build a Dashboard, several teams in my Org. can use. The idea behind this is as follows: There is a separate sheet, which gets filled by using forms / row update. Each Team fills out their row initially by using the form and then does updates on certain fields via a workflow. A Dashboard…
-
Macro or VBA funtions
the first question was in 2018. is there any update on getting VBA into Smart Sheet?
-
Is there a way to show the report and give edit access to add comments and add attachments?
I have designed a workflow for our team and used the Request system workflow as a start. I created a report and attached the link in the email when someone submits the form. I have this report linked with the underlined sheet where my entire team works. V have information that shouldn't be shared with anyone outside the…
-
Automating Prize Codes
Looking for SS Brain Trust for an Assist... I have a list of prizes I am awarding to qualified sales: 1) A vault of prizes in one SmartSheet with very strict access - one code/URL for every row. 2) On another workspace and SS, the entries are made via a form for qualifying sales. a. For example, if the sales order is for…
-
Charts built off of reports
I have some charts that are built off of reports pulling from multiple metric sheets counting data entered in the last 30 days, 5 days and 24 hours. The reports are set to look at and add only the items that have a number greater than 0 in the 30 days column as there is a huge list and we wanted to simplify that list to…
-
Sum formula using another sheet
I am trying to do a count of cases an investigator has completed between a date range (using a differen sheet) If I do a I have this formula in my Sheet summary and of course it works =COUNTIFS(Investigator:Investigator, "Vanessa", [Disposition date]:[Disposition date], @cell >= DATE(2020, 8, 1), [Disposition…
-
How to efficiently link data from one sheet to two other sheets
Hello, I'm trying to link data from a master sheet to two other sheets. Here is what I tried so far, but it's not working. Created a form on the Master Sheet. Tried Cell linking the master sheet to two other sheets. However the problem that I have is that because I am already using cell linking on this Master sheet to feed…
