bsikes✭✭✭

Thanks for the responses @Lachlan Stead and @Seth Morth I'm sure we'll go down the SSO route eventually as Smartsheet starts being more present in our working environment. In this case, we had a time crunch and eventually just pulled the trigger on a method that worked, but still didn't give us the consistency we wanted.…

I think a handful of AI/ML formula functions would be helpful. As an example, a new formula function that would accept a text input (likely a cell reference), as well as an array of "categories". The new function would then evaluate the text string and result in the category most applicable being chosen.

As an update, we were also going to explore using RPA to manually add each individual user through the "User Management" screen. The first user we added was only prompted to make a password and that was it. None of the screens we're trying to bypass appeared (they did have to do 6 different captchas...). However, the…

We have various scripts in-house utilizing the API quite a bit, and our log that receives timeout errors hasn't been touched since last Thursday.

I'm guessing it's a situation where the PDF generation uses the value of a cell, as opposed to it's display value which would have your formatting set. I think to get around it, you'd need to make another column that would convert the date to a string that's formatted as you'd like. Then use that new column in the PDF…

Thanks for the response @Jeff Reisman That's unfortunate, but is what I was expecting. To help facility our manual process, I've at least setup a daily process to get a list of all our Smartsheet users and cross reference those with our employee directory. If a user exists that's not in our directory we should be alerted…

Yep, CSV file had the correct content. For what it's worth, here's the PowerShell syntax I'm using that is working:

I'm able to export a sheet to CSV using a PowerShell script and the sample code provided for the API. One thing I did notice, was that I also received the "Invalid Accept header. Media type not supported." message when I didn't have the correct Sheet ID being used. So even though the message points to your Accept header,…

We don't have this issue with our documents. I think this may be a setting on the text field in your PDF template. (In the software we use, it's called "Multi-Line")

Running into this now. Would love to be able to have the option from a report to bypass the need for source sheet permissions. I'm trying to build a proof-of-concept dashboard that shows where the current user is within a process, but they can't have permission to the source sheet with commingled data. Functionally works,…