-
Is there a way to download SmartSheet form as a PDF?
I want to be able to use Smartsheet form as a PDF also in cases where I have to manually write information or use the form as a Job Sheet for Complaint/Servicing form. How can I do that? Any help will be greatly appreciated.
-
Count how many jobs start in a month
I am trying to create a formula that counts how many jobs are due to start in a month, that havent already been started. I have created the below formula to try and count the jobs in the current month: =COUNTIFS({Tippa JC Status}, ="", {Tippa Start}, MONTH({Tippa Start}) = MONTH(TODAY())) Then I try and modify it to the…
-
Do refresh token expire ?
In Smartsheet, the refresh token generated using the OAuth 2.0 flow , do they expire ? If yes, what's the expiry time ? (I'm asking for refresh token , not access token).
-
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…
