-
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…
-
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…
-
Deadline based on Priority dropdown menu
Hello all, I am using SS to process work orders. People fill out a form which has a priority dropdown column with classifications such as urgent, semi urgent, can wait etc... I wanted to see if i could write a formula in the deadline column to calculate a date based on the priority picked. ie- if someone picks urgent, the…
-
Dependency with Teamworks
Hello! I'm new to Smartsheet and trying my best to learn so please be patient with me. We are a small company and are starting to properly organize our team using Smartsheet and TeamWork but we're running into a wall. My boss found out that if you link TeamWork together they both share co-dependence meaning that if you…
