-
Random ODBC Errors AND SSIS Errors Saying Sheets doesn't Exist
Hi There I use Smart Sheet 32 bit ODBC component to connect to SmartSheet and pull data to SQL server. Suddenly I see errors randomly. There has been a random error appearing each time the SSIS package is run (SSIS package uses ODBC provided by Smarsheet), it is not stable with one sheet missing error. Each time the…
-
Calculate Difference Between Latest Entry and Previous Entry (Dates)
Hello! We are collecting weekly meter reading data (Meter Name, Reading Date, Actual Reading) via webform. I would like to create a calculation in a new column (within the sheet) that automatically calculates the weekly meter usage based on the meter name using current and previous entries by date. *For each Meter Name:…
-
SharePoint Deployment Plan Template
Does anyone have a Template plan to build and deploy Sharepoint?
-
Storing a SmartSheet form in a Sharepoint document library
I have a SmartSheet form I want people to complete, but want to use a SharePoint document library for all the submitted forms. What's the best approach to getting this done?
-
A formula for totaling question
I have a sheet that is tracking issues. One column is a category (bug, feature req, UI issue, etc.). The selections are defined in a pull down and isn't free form. I want to create a widget for a dashboard that shows the total number of each category option. It appears I can't do it directly so I thought of building a…
-
Drop Down Menus
Hello, I have a drop-down menu with a few selections and I want the next cell over to have a text based on what is selected from the drop-down menu. Can this be done? So on cell B3 I selected 5, and I want the word Tom to populate on cell B4 based on that selection. Thank you!
-
Establishing connection between Informatica Power Center and Smartsheet
Establishing connection between Informatica Power Center and Smartsheet
-
Using "@row" reference with ";" as the separator
Hi the community! I am using Smartsheet with French settings, meaning : * the decimal separator (for numeric values) is "," * the separator in formulas is ";" When I use the "@row" reference in a formula, then extend this formula and come back to it, the formula separator becomes ",". So if I modify the formula without…
-
Sharing a report but not the source spreadsheet
I want to share part of a spreadsheet with a subcontractor. However, I do not want them to have access to the full sheet. For instance, source data: A B C D E F G H Data to share with subcontractor. They also need to be able to edit/update columns A, B, C. A B C According to the help page, this is not possible, but maybe…
-
Help Desk Ticketing templates
I am working on leveraging the Help Desk template to manage our customers' IT tickets. Requirements: 1. I need for the submitters to receive an auto acknowledgement of their service requests. 2. I need for the technician to be able to communicate back and forth with the submitter via the ticket. This will allow the…
