-
Posting/Including data from another cell.
Within my sheet I have two columns that contain time (hh:mm:ss). In the third cell I am comparing the two columns. If they do not match a statement is posted in a cell stating something is wrong. What I would like to add to the statement is the value from one of the cells containing the time. This works, with no added…
-
Having viables on a form
I have a form that my company uses to enter new jobs on our manufacturing schedule, However we also do a select amount of installs. Is it possible to have the form be able to have a drop down menu (this i know it can) that when The questions is "Is this an install" the user selects "No" then all of the Install questions…
-
Hyperlink to a server (referencing cells that tell it where on the server it is)
Good morning, When I use excel, I have the ability to combine several cells together using the "HYPERLINK" formula, and am able to get a link generated automatically where it will point to an outside server and folder I'm working with. Excel does it perfectly, but I'm using SS to track things within a team. But it's 2…
-
Email Notification template
When I setup an email notification everything works fine. However, as an email marketing specialist it pains me to send out the data in such a standard (boring) template. Is there a way to edit the look of the emails that are generated through Smartsheets? This would be a huge benefit to helping sell this software to my…
-
C# API Add Records from MS SQL Server
Hello, I'm trying to get records from a SQL table into Smartsheet using C# and ultimately SSIS (via script command). I'm stuck on how to add the rows into Smartsheet. 1. I want to add the rows dynamically without having to code the column id. I see that there is Bulk Operations but very little documentation for it. This…
-
Curl GET request mixed results
Hello community, Just getting started and trying to leverage Curl to proof a few things out. When I issue the following example command, I get a list of my sheets successfully: curl -X GET -H "Authorization: Bearer " "https://api.smartsheet.com/2.0/sheets" When I issue a more specific command listing one of the sheet ID's…
-
Smartsheet API - document generation and attachment to row.
Been struggling a bit with recent smartsheet api development and was hoping for some insight as to how to handle the following situation: To bypass the restriction of 5000 rows per sheet, I'm developing an app using NodeJS sdk that will run on a scheduler in the following fashion: If row count is 4500, next time this app…
-
*** Times of execution of a requirements with different people assigned*****
Hi everybody, I need your help. Currently, our requirements request process is as follows, enter the form within Smartsheet register the emails of the people who want the application to send, Then these people receive and assign other resources if necessary. It is important to indicate that it is a single requirement that…
-
Looking for a Guru to Build a Smartsheet + Quickbooks Solution
Hi I have a small engineering company 15 people that has not been able to find a real good Portfolio management solution so am considering creating my own with Quickbooks + Smartsheet. I use Smartsheet for managing commissioning projects so would expand this to include all of the 125 projects we currently have on the…
-
workflow automation
Are you considering to incorporate workflow automation to Smartsheet ?