Need help building your Solution? Explore the NEW Smartsheet Implementation Services Portal
Hi Community, Exciting news! Smartsheet is proud to announce the launch of our Implementation Services Portal—a one-stop shop where you can purchase select Solution Package service offerings to accelerate your Smartsheet journey. Delivered with unparalleled expertise, Solution Packages address business challenges across…
How to embed HTML hyperlink into form submission email
Hi! I love Smartsheet but I can't seem to find a way to do the following: After a user submits a Smartsheet web form entry to populate my sheet with data, I'd like to embed a hyperlink into both (if possible) the response and email confirmation so that the user is directed to a web page on my site for next…
Assigning people to tasks randomly and with a condition
Hello, I would like to randomly assign service representatives tasks, but only those who meet the criteria of already completing a task previously assigned to them. I would like to create a workflow or formula that would assign individuals on their availability and at random. Any suggestions?
Average based on 1 criteria
I'm sure this is user error but I'm trying to average out compensation based on the job code then I'd like to create either a data mesh or vlookup to fill in the blank compensation with these averages. I've tried having a seperate sheet that has the job codes and then I'm trying to use the averageif formula. However I keep…
Salesforce Integration- Worth it?
Hi everyone! We currently use Salesforce, Quip & Smartsheet however, we have not yet added the integration to sync them. Can anyone tell me what the huge advantage is to justify the price of the integration? The video links are a bit vague & I need to provide a few good reasons, other than an auto alert if a new…
Generate documents from parent and children rows
Is it possible to generate one document from multiple rows? Best example I can think of would be an itemized order with multiple items in the order - how can you list all order items from that parent row (order number) with the item ordered [qty, price, detail information] on the children rows? Having columns to fill on…
Last day at ENGAGE!
As a new user of Smartsheet I came without big expectations. Three years ago I new about Smartsheet I was like "Why I would invest time on another Grid based platform...". I am an Excel, CRM, ERP guys.. So I passed at that point in time. However.... This has been one of the most productive conferences I have ever attended.…
Using checkbox to add value in another cell.
I am not an expert on excel but I am trying to add value (more specific: adding date/time or just time automatically) to another cell just checking a check box cell. Is this possible on smartsheet? Thanks. Al
Can't add a column to a sheet
I have the paid version (for years) of Smartsheet. For some reason on one of my sheets, I cannot add a column. Any help? Thanks! Jennifer
Cell Linking not working
Good Afternoon, I have a report which collates all monthly figures from each Months Tab, and links them into a Detailed Yearly Report for my figures. This is starting from 2018, but ive got down to March 2019 and now the Linking doesn't appear to work. No matter how I do it, the link doesn't show inside my column. Is there…