-
Outlook Calendar integration showing time of event and not just the day,
Smartsheet is great for planning events but when that date is added to an Outlook calendar, it shows up as a day event and not the specific time of the event. Not only does it look like a day event but the inability to change the calendar to the appropriate time of the event is creating more work. It would be great if this…
-
Is there a way to grab attachments from a new line in smartsheet and merge it with the print file
Hi, I have been trying to work on a system that will automatically take attachments from a new line in smartsheet and be able to merge it into 1 pdf file with the print pdf of the smartsheet line. I have tried using power automate to computerize this process, but there is no option for me to grab attachments. I have…
-
Identifying paid user accounts via the API
Until recently it's been possible to identify licensed, paid users via the API looking at the licensedSheetCreator attribute. However, with the recent changes to Resource Viewers it seems that it is possible for the API to return users who are non-billable resource viewers with licensedSheetCreator: true . This is leading…
-
API connection from Smartsheets to R
Hi, I am attempting to connect Smartsheets to R. I have tried to use the SMARTSHEETR package but having issues with the code and loading a sheet. Has anyone has success with this and could share their code? Thank you
-
Unable to input external data to SmartSheet through API
Hi community members, I'm working on a project to fetch our students' quiz score data from Blackboard, an education platform, and send it to Smartsheet using the API. I've successfully retrieved the data from Blackboard and prepared it for transfer to Smartsheet, ensuring the data is correct and the column IDs match those…
-
VLOOKUP: How to make into a Column Formula?
Good afternoon! I have the following formulas that I need to convert to a Column formula, any ideas? =VLOOKUP([Assigned Tech]2, {Team List Range 1}, 2, false) =VLOOKUP([Model Number]1, {Master Parts List Range 1}, 2, false) Thanks! Ashley Pierce
-
Deleting Columns using API and python
I have a column that is identical on hundreds of sheets. I am attempting to delete the column using python and the API. I am currently just trying to delete it from one sheet using a script as a proof of concept for all of the sheets that have it. The column in question is a date column with a column formula. My…
-
Can't see check boxes or symbols. PLEASE HELP!!
Hello, I hope someone out there can help. For some reason today I can't see the checkboxes on my sheet or the symbols when editing the column type. I can't see the symbols on the sheet or in the dialog box that pops up when trying to change the symbol type. I can see symbols in columns on an old sheet where the column was…
-
Extracting data from a host server
Hi, I work with a developer and designed a website for an organisation. On this website people need to fill in a form and submit it. This gets uploaded on a data server where it is stored. The data can be exported as an excel file, but I was hoping that through an API Smartsheet can collect data directly. Is this possible…
-
Transfer ownership to another user using API.
We have requirement that we need to transfer ownership to another user using API. I didnt get any API for transferring ownership to another user. but i got one RemoveUser API. i tried with the api https://smartsheet.redoc.ly/tag/users#operation/remove-user But i got the below error while using the above api…
