-
Automatic sorting
i have a sheet that has data with dates added from a form. it always adds a new request from the form to the top and i have to manually sort it by date in descending. is there not a way to have it automatically add the data by the date in descending order?
-
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…
-
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.
-
What is the max number of sheets a user can create in Business plan?
Hello everyone! I've checked this page https://www.smartsheet.com/legal/limits-policy it doesn't show the storage limit not the numbe of sheets limt. I need to know this because we have hundreds of projects we were planning to put each one in a sheet but if theres a limit to sheets number maybe we would have to groupe…
-
Using Smartsheet Merge Add-on for Google Docs Problem
Hi All, I dowloaded the add- on of Google Docs with smarsheet, and I was able to connect it successfully to my relevant sheet in smartsheet, When I tried to add the relevant data to each row in my table, from each row in my smartsheet sheet it created a new table in a new page. Is there a way to embed the data from each…
-
How to prevent the auto adding blank rows ?
Hi all, Smartsheet keep adding new blank rows to the bottom of the sheet even though if they are deleted manually . Is there away to prevent the auto inserting new blank rows ?
-
Improving wayfinding/navigation
Currently wayfinding in smartsheet is quite clunky, as via File > Properties is the only way find where we are located, or to jump to another place in the folder hierarchy. It would be great to have these breadcrumbs surfaced on every page in smartsheet.
-
Why is one sheet workflow bringing the cells to the top and 1 sheet is bringing the cells bottom
I have two sheets that workflow to a separate sheet. One sheet will put the cells at the top and one will be brought to the bottom. How can the cells be workflowed to the top of the separate sheet.