-
Smartsheet Maps - Multiple Pins
Good afternoon I have a spreadsheet to uses City, Country and some Zipcodes to get a loose placement map for ~200 locations Most addresses are loading in without issue but I am having issue with multiple pins in the same city when zipcodes information is not available (especially outside of US). Is there anyway to have a…
-
IF function/moving row's across sheets
Hi, I have multiple project sheets, whereby each row represents information about a project. I would like to know if there is a feature whereby if i was to enter into a field that this project was complete, that the entire row could be moved to a new sheet for completed projects. E.g. if i were to enter a "tick" or the…
-
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…