-
Extract Email Address from Contact Column
Hi, I am looking for a way to use Bridge to extract the email address from a contact and update an "Email" column in the same row for a record, when added. I assume this can be done with Java Script but I have no idea where to start!
-
Syncing Smartsheet calender with Outlook
I have been using the Smartsheet calender for awhile but we use Outlook calendar at work and I was wondering if there was a way to sync my Smartsheet calendar with my Outlook calender. Is this possible?
-
Date with Time uploading in Data Shuttle comes only with Date
Hi Everyone, I'm uploading Input excel having column value "6/1/2022 1:22:23 AM". But after uploading into SmartSheet, it comes only date "2022-06-01". I need exact format which is in my Input file. Anyone help me on this. Thanks, Sandhiya P
-
Sheet Historian - grab snapshots of a sheet and append them to a Data Table
I'd like to be able to grab copies of a sheet and append them to rows in a datatable so I can build a "historian" over time. This is the use case: I have a sheet that all our project managers use to capture the Cost To Complete (CTC) for all our projects. Each week the PMs are asked to update this sheet with their current…
-
How do you create a pivot card in Pivot App and what is it?
I am new to Smartsheet's pivot app. I normally use the Log in with Smartsheet button in the Pivot App to create a pivot table but I wanted to try the "Pivot Card - Create a Pivot card" below the normal login, however when I click on the calendar button, nothing happens. See screenshot. Can anyone help explain what a pivot…
-
Data shuttle is not running on time
Hello, We have multiple data shuttles setup to run at 5:00 am UTC and to repeat every 15 minutes with an end time of 4:00 am UTC. We effectively need these shuttles to be running every 15 minutes nonstop. For whatever reason the shuttles will stop running for no apparent reason and will not restart without us manually…
-
Dynamically Scheduling Another Workflow
This is my first time trying to have one workflow dynamically schedule another and I must be doing something wrong. What I want to happen: On our main customer workflow, it is triggered by the specialist changing the Stage status. When they change to a specific stage, an email is triggered to the customer via our SendGrid…
-
API: Missing userPermissions and workspace fields in get_sheet response
Hi, I have been using Smartsheet API for a while. I invoke my Python scripts to read sheets and do all sorts of stuff. I created a new developer account recently. Then I created a new sheet and tried to read it using my scripts. I realised that the response is not returning the field userPermissions which is usually…
-
Does the Smartsheet Calendar app allow ownership transfers?
I'm attempting to transfer ownership of all my Smartsheet items, but am struggling with some of the premium applications in finding a way to transfer the ownership without the new owner having to rebuild everything. Specifically the calendar app is giving me trouble (data shuttle too!). Does anyone know how you can…
-
Employee Product Purchase Program
Hello! Currently we are tracking leftover furniture product for sale to employees using a basic smartsheet. We want to be able to allow all employees to view product details and photos of the product for sale AND be able to request the items they want to purchase (first come, first serve). My first thought is to use…
