-
Calling Custom APIs from Smartsheet form
Hi All, we have a simply custom API which will take as input an employees ID and return their management chain. We would like to call this API as part of a simple smartsheet form we built such that their supervisor's ID can be inserted as part of the record in the smartsheet. Are there instructions as to how to embed a…
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
Update Picklist via API
Hello, It don't see the API hook to update a Picklist. I would like to keep a set of shets and snc and thought this would be the easiest way. I thought it would be with the columns: https://smartsheet-platform.github.io/api-docs/?javascript#columns If it is not there yet, could I request that enhancement? Thanks, Brett
-
Zapier and duplicates
Hi all, I'm hoping to tap into collective wisdom to sort out my problem. I'm trying out Zapier to do the following: if a row is updated with a date in the future, copy it to another sheet, only once. If the date gets updated again, I don't need to create a second copy. I created a Zap which works well, except it copies the…
-
Searching multiple sheets
Is there a way to search multiple sheets when using a filter? Frequently we have multiple properties in the same subdivision and we are looking for a specific lot/block. The filters on our sheets work great we just have to do it multiple times to search all sheets. Just looking for a time saver. Thanks for the help!
-
Skype for Business integration and Card View
Anybody out there had better experience trying to get the Skype for Business chat integration working in Card View? It looks like you have to go to the Contact Column in Grid View for it to work best?
-
Smartsheet labs connector to DocuSign not working
Smartsheet labs connector to DocuSign: I enter my DocuSign user name (the email address associated with my docuSign account) and DocuSign password on the smartsheet labs connector to DocuSign page. Smartsheet labs error message says Authentication Failed. My user name or password is incorrect. I assure you, I have entered…
-
Product Key
I need my product Key for run powershell command. Where I can find them?
-
Anyone having issues with Outllok app uploading attachments that are NOT checkmarked?
I submitted an email to support yesterday but have not heard back. I'm having an issue where I uncheck attachments I do not want to upload to SS and it's ignored and uploaded anyway. I then go into SS and delete those attachments. For a lengthy email chain, there could be a lot of jpg's from signatures that do not need to…
-
Integration with Orchestrated Beer
Orchestrated Beer is an SAP Gold Partner - is there a way to integrate into SmartSheets?
