-
Formula/pie chart help?
I'd like to have a pie chart that shows a dynamic count of orders "pending/fulfilled/cancelled" of the last seven days. Ideally, there would be four separate ones for four locations (which will be presented on their personal dashboards), as well as a master graph that compiles the data for all four into one for upper…
-
Form from one sheet populates another sheet
Hello SS gurus, I am relatively new to SS "in the field", although I've watched over 20 hours of videos from the SS Learning Center so I have a good understanding of the mechanics. Here is what I'm trying to do... We need to track inventory in our supply room: items on hand, items removed, items added, etc. We would prefer…
-
Enable Form text entry when Dropdown List is not restricted
When a column is a Dropdown List, one can choose whether or not to "Restrict to dropdown values only," however, when a Dropdown List column is used in a Form, only the dropdown values can be selected. Please update the Form functionality to allow free text entry if a dropdown value is not selected.
-
Pasting from Excel triggers an Automated Workflow
I received numerous one liner emails daily from a customer with consistent data I need to action against. I'd like to paste from Excel into a Smartsheet GRID and then a workflow be triggered to validate information and email notify the respective parties. However, when I copy and paste it doesn't trigger, what do I need to…
-
Helper columns
Hi there, Is there a tutorial on helper columns? Helper columns have been suggested to me, and I'm sure they will help our group but I am still confused on how to use them. Thank you! Esperanza
-
How can I create new entries/rows and make sure the link's rule applies automatically to them all?
Hello All, I created a mother sheet called Product Development which we populated via it's online form. I created a secondary sheet ( daughter sheet) called Costing in which the majority of the columns are linked to the rows in the mother 's sheet. I added a new last row but the Links to the secondary sheet are missing.…
-
HH:MM sum formula in Smartsheet
I have a series of times that our staff spend on a particular activity for a month in format HH:MM as shown below but I'm struggling with how to create a formula in smartsheet that allows me to sum these values are report the result in the format HH:MM too? Can anyone assist?
-
Referencing the last comment to update a column
Hi Community, I've started a Software Issue tracker and so far I've found ways to display the information how I'd like it. I hit a road block when trying to display the latest comment a field on the spreadsheet. I'd still like to use the comments thread so other Project Stakeholders can reference the communication for each…
-
Excel Sheets as the base content for Dashboards
Hi- I have team members that are very resistant to anything new. They want to continue to use Excel for their spreadsheets and wonder if the Dashboard and other sheets that folks use in Smartsheets can actively link to their Excel sheets instead of actually having a SmartSheet. I know that Tableau does this - it links to…
-
Consolidating output from multiple forms onto a single line in a sheet
I am quite a new user so apologies if this is quite a simple task I have a multi stage process which relies upon collecting information from 3 different sources (for which 3 forms have been developed), but as the information all relates to a single request to procure a vehicle, which is being tracked on a single sheet, i…
