-
Formula needed
I am trying to set up a formula that will subtract from a given value, each time that item is found. I have a form that my team will be using to enter data (item) and how much they found (subtract from value). In turn, I need to have a running total of what is still not reported for each item.
-
Reports - Hide the original sheets
We have master sheets that contain information on all products across 6 factories. We want to create a report for each factory that they then update relevant information for their products. This then allows all data to be viewed in the master sheet. The problem is that the report will show only the products that they have…
-
Weeks Out Calculation based on Nested IF Statement
I'm having trouble having my weeks out calculation work based on the results of a Nested IF Statement. The If Statement works if I use quotation marks around the results which need to display a date. The problem is that putting the quotes around the results converts the number (in my case a date) into text and no longer…
-
Regular Expressions (RegEx) with FIND function
Hi Team, I'm guessing that SmartSheet doesn't support regex in formulas as I get an #UNPARSEABLE error when I try it but I thought I'd better post the question here before I make that assumption. I have the following text in my "Subject" column: [1751] - Guide Posts With the formula: =MID(Subject1, FIND("[", Subject1) + 1,…
-
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…
