-
add a source sheet or column to a report?
Is it possible to use bridge to add source sheets to a report? Also, it is possible to add columns to reports with bridge?
-
Using Smartsheet Forms as multi lingual survey tool
Hi, I am using the forms function to collect data from people in many different countries. The information we are collecting is in binary, single select, and multi select formats. This information is being summarized in a separate sheet, where we are counting the instances of each response from the binary, single, and…
-
Can I populate multiple lines in a report from one form
I am trying to automate our joint health and safety checklist. I have created my data sheet with 88 columns and created my form. Each question has a drop down with yes, no or N/A. When no is selected a comment box comes up to insert the issue. What I want to do in my report is create one row for each issue that arises…
-
Project Planning: Percentage Complete from Dates
Hello I'm currently using Smartsheet for project planning. I want a forecasted percentage complete on progress to date from baseline start to baseline finish. Can anyone help please? Thanks in advance! :)
-
I need a report that only shows particular sections of the project, Is there a way to do this?
I have done a work around by exporting to excel and removing sections not required but I would like to have a report created based on a range of rows and put in a dashboard. Thanks
-
Can a report automatically update (add rows) as the sheet behind the scenes is constantly adding cel
Can a report automatically update and add the rows that the sheet it is being used on? My sheet is constantly being added to and I would like the report to also add the cells when the cells are added in the sheet.
-
Calculating averages based on specific criteria per week.
I have a smartsheet that I am trying to find an average rating per week if there is specific criteria in a column. I've condensed the columns I'm trying to find an average of below The 'Created' column is an Auto-Number column for when the data is entered. I'd like to calculate the average, or 'Over All Rating' for each…
-
Report showing Yesterday's form submissions, only if not a weekend
I've got a report showing form submissions from YESTERDAY, but on Mondays, the report will be blank. I need it to show the previous work day's submissions (it calculates an average daily score). Is it possible to filter this report to show the last WEEKDAY's submissions? @Paul Newcome
-
Is there a way to use automation across grids?
We're using Smartsheet to track project requests. I'm working to build "personas" to show the type of projects coming in based on the requestors job function. Is there a way I could use automation to add data from another sheet so that once we receive a request the automation can reference the requestor's job function and…
-
Dashboard report not showing in Desktop
I have a report in gantt view that is not showing in a dashboard online. I'm using Chrome to access. The source sheet, report, and dashboard all are published with read only full permissions. When I pull up the website in view only using the public link, I get the the following... Is there a workaround so that the report…
