-
Sheets with Formulas & Web Forms
Whats the best way to handle a sheet (with formulas) populated by a web form? Right now, each Web Form populates at the end of the sheet, where the formulas stop, how can I eliminate that from happening?
-
Card View Lanes / Drop down
I'm using a sheet populated by a web form and using Card View as "Default" View. Card View is Viewed By "Machine Submitted By" The "Machine Submitted By" is a drop down selection on the Web form Is it possible to have "COMPLETED" as a lane on Card View WITHOUT allowing it to be a selection on the web form dropdown?
-
Sheets populated by Web Forms
I have a sheet that is populated by a web form. * The production floor inputs data into the web form. * The quality lab is "View Only" on the sheet. (on a display screen) Is it possible for the sheet to auto-refresh when new web form results have been added? The goal is - as soon as new info is added from the production…
-
Count Blank Cells
Hi I am using Smartsheet for invoice approvals and would like to summarise how many documents are still awaiting approval. I have tried using a countif formula to count all cells that are blank in a certain column, however I get results that include lines are not used, e.g. there are 10 documents entered on separate lines…
-
Update requests
Hi everyone, I have built a sheet in smartsheet to track supplier performance. When there is an issue with their performance, I am wanting to send the supplier a update request in order for them to provide corrective action for problems and it to be written directly into the sheet. This works great but to provide context…
-
Past Due Reports
GOAL - Tasks Past Due Report for Multi Sheets I have several sheets with the columns set up as seen below: (Type 1) Rows have Tasks with a Contact under Assigned to, "Required" column has a symbol and % Complete is not required so it's left Blank. (Type 2) Rows have Tasks with a Contact Under Assigned to, "Required" column…
-
Advanced Notifications: Stay on Top of Important Changes
I have been waiting for these more advanced notifications for a while now. Thanks for getting this to a much happier place. I tried creating a generalized "team" notification when any given shared user is assigned a task, I would like them to receive the notificaiton. From what it looks like currently, this is possible,…
-
Formula to add or subtract value based on item selected in drop down list
Hi folks, I would like to create a formula that can identify the item selceted in a drop down column and then automatically add a value based on the item selected in the drop down to the next cell. Example if the item i selected from the dropdown list in column a was "deduct 10 points" I would like the formula to…
-
Conditional Notification / Alerts
Hi Smartsheet Community, I recently posted a reply on the smartsheet blog (https://www.smartsheet.com/comment/46032#comment-46032) and Diana Ramos kindly replied letting me know that Conditional Notification might soon be available. Diana asked me to add a thread here to capture and direct the programmers to ensure our…
-
Sights
I am using smartsheet to collect problems and ideas coming from various areas of our company. As a result I have a large sheet in smartsheet where all the data is being collected and then I am using sights to display an overview of problems and ideas. My query is where is the best place or method to gather all the…