-
List totals
I have a sheet that lists all of our clients by project. For reporting, i'd like to see a final report or dashboard widget that lists the clients name in order of most mentions within the original list. For example: List A Joe Doe Freddy Mercury Alice Chains Eddie Money Joe Doe Eddie Money Joe Doe Report: Joe Doe - 3 Eddie…
-
Enhancement request - smarter autofill for dropdown menus
In a column using a dropdown list of options, it would be great if autofill was smarter - specifically, if it would suggest options based on any word in the list of options, not just the first word. For example: Typing "West" should bring up options like "Broadway Street West" or "Northwest Broadway" not just "West…
-
Text in one column show date in another.
I am moving a complex (static) spreadsheet to Smartsheet! One of the key drivers ensures that we show the date and the fact that it is NPI. In the Excel spreadsheet we have numerous columns (about 11 years but moving forward it will not be that big) showing Month/Year * When you enter NPI in one of the columns, then the…
-
Comments column on web form
I am looking to create a webform that has the comments section. Now from what I have read thus far, it seems impossible to do. That if you want a free flow text field, you need a new column and have it as such: comments. However, some comments can be extensive. And if you wrap teh text, teh smartsheet becomes out of whack.…
-
Extracting all instances of a word from a text string and creating a list in a separate cell
Hello all, I have been pouring through excel and smartsheet help forums for a couple of days now, and I haven't seen my issue asked or addressed so thought I'd ask here. I have, in one column called Terms, cells that contains lists of terms and phrases. For example, one cell contains the following text string:…
-
Timelines
Hello Community! Is there a way to make a timeline in days instead of in dates? Like total timeline of 2 weeks as opposed to 1/1/19-1/14/19? Please help me out!
-
Use triggers from Smartsheet?
Working on a new workflow. Today's workflow is manual and based on emails. I'd like to use the webform to collect the required data (done) and then, based on specific conditions in the sheet fields trigger actions in other system - from generating email to open a service ticket etc. I watched the movie of the docusign -…
-
Parent row based on children status and due date formula
Hello, I have a sheet that tracks event deliverables for 150 or so events each year. The way the sheet is set up each parent row is the event name, and then the children rows are each task for that event. I have a column for Status with the options for Complete, Not Started, and In Progress. I want to create a new column…
-
Select SmartSheet Alerts not sending
Hi there, I am setting up 3 alerts for a sheet: 1) When a new row is added (via a Form) 2) When an "Approved" column is checked 3) When a "Done" column is checked The first alert sends an email. However, I am having trouble with the last 2. Email alerts are not being sent for some reason. For testing purposes, I currently…
-
Counting RYG Balls
Hi guys, Is it possible to count the number of balls according to their respective colors? Many thanks in Advance.
