-
Prefill Webform with QR Code
Hi all! I've been playing around with webforms and data stored in QR codes for my company. What I've got is when I scan a QR code, it sends me to a Jotform survey that pre-fills fields from the QR code into the form fields. For example, the data stored in my QR code looks like…
-
Method of linking data from source sheet with an increasing number of rows
The function I am looking for would allow for data to be pulled from a source sheet which is increasing in size and be kept in sync for maintaining accurate information. To help explain, at the moment I can link an entire column of 'Engine numbers' with number n (approx 300) rows and the corresponding data with no problem.…
-
hide certain columns per user
Basically: I want to hide certain columns for specific users. In detail: I have 7 users shared to an affiliate sheet. This sheet contains the assets needed for marketing as well as rev share and money exchange. I want my graphic team to update the status of graphic assets but I don't want them to see the rev share columns.…
-
Assigning a unique favicon / thumbnail
Is there a way to assign a unique favicon / thumbnail to a smartsheet forms URL? So that a smartsheet forms URL once added to a IOS or android device home screen can be something other than the smartsheet check mark. Thanks.
-
SQL Server to Smartsheet
I want to fetch live data from SQL Server and make reports from it in Smartsheet. How can I do that. I have live data connector and Cdata. How can I export data from SQL Server to Smartsheet ?
-
Improved Way to Alphabetize a List Using SMALL()
I have a project dashboard that links in data from several other sheets to show an overview of project financials and time charges. In a couple of cases I needed to sort the results by project number which includes four numerical characters, occasionally followed by a single alphabetical character, none of which I could…
-
Smartsheet JIRA 'OR' vs 'AND' in filter
I just received Smartsheet JIRA integration training and I though I remembered seeign that you can change the filter operator to OR instead of AND when adding multiple criteria - however I cannot see how to actually do that. Can anyone assist?
-
Smart Sheet Freelancer Required
Seeking an independent Smart Sheet Consultant to begin work no later that the 31st October 2017 6:00 PM GMT You should be able to screen share and use our already uploaded excel spread sheets to create reports.and sights. You should be able to use the advanced functions of cell linking and formula to create forecasts.…
-
Need help with date range overlap formula
Please see attached screenshot. I use the "Duplicate" column to show whether or not there is an overlap in the date range between new entries and the "Start Date" & "End Date" columns. In Excel, the following formula works great: =SUMPRODUCT((D2<enddate)*(E2>=startdate))>1 I know that Smartsheet doesn't support SUMPRODUCT.…
-
Reviewing Alerts & Rules for errors
Hi all, I've searched high and low but I can't find a way to do this easily. Is there a way to export all the notifications and rules set up for a sheet for ease of review against the process? Basically I want a report of all my notifications and rules layed out in a table so that I can review them against the process for…