-
Developer needed....
I'm looking for a developer to help a business with a business / operations set up and on going support. We currently use Smartsheet and want to extend our use of it - manage projects, flow, contact with clients, contact with consultants.
-
Column Number Function
Hi is there a function that can return the column number when given the column name? This would help when columns are added in sheets that have vlookups referencing them.
-
Integrate with Microsoft Access
Does Smartsheet allow for integration with Access database tables? Is this something that a connector is needed for; such as Data Uploader? Will the integration work with older editions of Access or only Microsoft 365?
-
Integration with Oracle Primavera P6
Has anyone had any luck with using API's or exporting/importing Smartsheet scheduling projects to Oracle Primavera P6? We are using the cloud version of P6 and both it and Smartsheet technically have open API's so it should be possible. However, rather than recreate the wheel, I'm wondering if someone has already worked…
-
Calendar app filter
Hi there, I create a data sheet that connect to calendar app. I have a column with checkbox. is there a way that if I check the box in that column the data on that role will show in calendar app thanks, Jess
-
Mass file transfer from One Drive folders to Smartsheet Attachments
Hello, I'm wondering if this is possible through the One Drive connector, any automation tool, or API. I have roughly ~1,000 folders in OneDrive, and the folders are named by client ID. Each client has 1 row in a smartsheet tracker, and the primary column is the client ID. The goal is to have all of the attachments in each…
-
Conditional search and return
My "Start" column has dates for each row; the "Primary" column has ~20 unique values and the sheet has ~80 rows with no parent rows; the "Task" column is mostly unique in each row instance. I am trying to return the minimum "Start" value to an "Order" column based on some keywords in the "Task" column for every unique…
-
Smartsheet - Azure DevOps integration
Hey guys, I'm trying to create a connection between Azure DevOps and Smartsheet but I'm having a lot of issues with it. Has anyone ever made a two-way connection between the two? Especially being able to update an item in Azure when a row is updated in Smartsheet (and vice versa)? My goal is to be able to update fields in…
-
Formstack pdf returned to Smartsheet
Our current setup is Smartsheet information to Zapier to Formstack which emails the pdf to us. I would like to have the form sent back to Smartsheet, to cut out the email, & according to Formstack (Overview tab) it is completing this process however the form does not appear in my Smartsheet and I do not find that it has…
