-
What is the best way to consolidate data from multiple sheets to a single row
Hi, hope someone can help me. I am using smartshheet as an internal onboarding process. This process requires me to collect data from 2 webforms entry for same client that autofills 2 different smartsheets, one smartsheet with about 20 colums and other with about 35 columns, OR a single webform to a single master…
-
What's the difference between zapier and azuqua?
Just trying to understand my options. I use zapier right now but keep hearing about azuqua. Any advantages of one over the other? Thanks
-
Mobile App for iPhone - Cell Fill Color Problem
Hello, I created a sheet that has cells, some of which contain no values but still have fill color, which I used to create borders so that it is easier to visually distinguish between sections of the sheet. The problem is that without any values, formulas, or anything else in the cells, the fill color does not show up on…
-
MS Project & Smartsheets - working together longterm
My client is refusing to come off MS project and wants to collaborate on project plans. Does anyone have experience if it is feisable that long term we can send a project plan back and forth but one person uses SmartSheet & the other person uses MS Project? thanks Nadia
-
User Interface
I guess many of you are using Smartsheets to great effect in many different ways. Some of the ways I am configuring it for my clients is to act as a service request/ticketing tool (for cleaning/maintenance tasks). Customers fill in service request forms, which creates a new row in a sheet. There, a manager adds a bunch…
-
How can I automatically capture date of entry on form
Hello - I've setup a webform for users to enter information about potential participants in a program. I want the form to automatically capture the date when the form is completed. I had initially set it up where I established a date field on the form but hid it from users. I thought by selecting 'Today' from the drop-down…
-
hyperlink to an address on our network
Is there any way of using an hyperlink to an address on our network. Possibly a third party app?
-
Super cool! Box integration and email upload
We use Box.com to store and collaborate on files with both internal and external colleagues. If you do too, here are two cool features you may not know about. 1) You can "attach" files stored on Box to your SmartSheet row. When a user clicks on the link to open the file, a new browser window opens inside of which Box opens…
-
Smartsheet merge for google doc
Hi all, One of my departments is using merge for google doc this works fine. But I wanted to try to merge a report but this is not possible. I think it is nessesary to present a report in a more document form. Ofcourse it is possible to do it from the original sheet but you need to scroll allot if you have 100 rows.
-
Webforms: Auto hide based on answer of other field; Alerts based on answer of field
HI, I have a few questions. Scenario: A team fills out a webform every time that a they take a call. There are different fields available to them to fill in. Some of these fields(especially towards the bottom) do not apply if one of the first fields they fill out are filled out with a specific answer. each of these fields…
