-
Lock a Field
I have a field with a formula in it and I want to be able to lock it so only owners and admins can edit. i cant lock the row as details have to be changed by editors in other fields in the row.
-
Field Employee time tracking software that integrates with Smartsheet?
I'm looking for a time tracking solution for field employees that integrates with Smartsheet. In our organization we have a master project list sheet that compiles project data for all of our active projects. Our field installers are currently logging their time using T Sheets, they're clocking in/out as well as selecting…
-
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…