-
Numbers importing as Scientific Notation
I am working with PO#'s in a smart sheet and joining this data with a SQL database to combine a few tables. I use a visualization program called DOMO that I use to import the smart sheet data and the SQL data and join within the program to make one dataset. The problem I am having is when I import the smartsheet the…
-
UI "Enhancements"
I know I'm not alone in my dislike for the new "hamburger menu" feature. It has resulted in quite a bit of retraining at our facility, across all 3 shifts, sucking time from my already packed day. The additional clicks necessary to access "active" sheets for the day is almost exhausting. While I certainly hope Smartsheet…
-
Can you auto-replicate rows in a sheet based on a cell value?
We're putting together a Proof of Concept for our project management team. We're "this close" to being able to replicate all the functionality they need. But, we're stumbling on one item. They would like Smartsheet to automatically replicate a row when the value in one of the cells is set a certain way. Specifically,…
-
OpenAir Plugin?
Is there a plugin to OpenAir? https://www.openair.com/index.pl
-
How do you resolve modules to use the smartsheet npm package on nodejs?
I am trying to use the Smartsheet API on nodejs (v8) on windows. When I add the smartsheet npm package, my solution no longer compiles. Easiest way to reproduce (though it reproduces without using create-react-app): > npx create-react-app solutionname > cd solutionname > npm start It works - your browser comes up with the…
-
Keeping persistent dates for status changes
Building a kanban board with typical IT cycle states: Ready, Dev, Test, Deploy, Done. I'd like to track cycle times and throughput. I've created (locked) columns to capture a status change for each of the cycle states; e.g. Dev Start and formula "=IF(Status@row = "Dev", TODAY())". That works to capture the date that a task…
-
Datamesh
Good Afternoon Does anyone know how to use Datamesh??? I am having trouble getting it working, any tips??? thanks in advance Michael
-
Smartsheet SMS Functionality
Has anyone successfully integrated Smartsheet with an SMS service provider? I'm looking to be able to send SMS reminders and alerts to contacts on Smartsheet on a scheduled basis.
-
Using JQL in the Jira + Smartsheet Connector
The help article located here - https://help.smartsheet.com/articles/2476121-jira-workflows#fieldmapping States that you can use JQL to define filters for the workflow. Quoted here... "You can use one of two methods for defining criteria in Jira filters in your workflow: * Jira Query Language (JQL)—Although JQL requires…
-
Scanning a Barcode
Does anyone currently know if smartsheet is capable of capturing data from a bar code?