-
Export Smartsheet as CSV using API - "media type not supported"
I'm able to export a smartsheet document as JSON with the API, however, our endpoint doesn't support nested data. So I'd like to get it either as flattened JSON or CSV. Sample #4 here shows the CSV option: // Sample 4: Get sheet as CSV curl https://api.smartsheet.com/2.0/sheets/{sheetId} \ -H "Authorization: Bearer…
-
Power automate integration with Smartsheet
Can someone please help me how to integrate power automate with Smartsheet. I'm using sandbox environment in Power automate to test the scenario, but was not able to figure out how to connect them. Use case: To use Smartsheet column values to automatically update one-drive excel dropdown.
-
Update request automation email does not include custom instructions
Hi. My update request works and sends bi-weekly with reminders. The issue is that the custom text that I created to give instructions like due date is not included or is cut off. For example, the subject line begins with custom text and instead of pulling in the due date, it will display - Update date. Then in the body of…
-
Quickly delete Sheet Summary
HI there! I think that I already know the answer to my question but I am hoping that the Community will tell me that I am wrong 😊 Is there a way to quickly delete ALL of the fields in a Sheet Summary without having to select the kebab and the scroll down to "Delete Field" for each individual entry? Here's where I am at: I…
-
Moved: Move Attachment Based On Key Data
This discussion has been moved.
-
Move Attachment Based On Key Data
Is there a way to move attachments from one sheet to another based on key data? IE: We have a sheet that includes a lot of the 'pre-completed' process, and final product PDFs are uploaded as they're created. We then have a sheet where we track information related to the final products. We don't want to use Move/Copy as it…
-
How to calculate the % of complete activities under each parent row.
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
-
HYPERLINK Function
Hi @Genevieve P., @Paul Newcome, Cc: @Art Schneiderheinze, @AJW, @Andrée Starå Are we any closer to getting a HYPERLINK() function in Smartsheet? Something with a familiar syntax such as... = HYPERLINK( Link_URL, [Display_Label] ) I know this has been discussed on many old threads, but I have been able to calculate a…
-
Linking dropdown options to member lists
I'm checking out the new Linked Columns feature in Table View and loving the idea of it, and that has me wondering if there's currently a way to link the options in a dropdown to the current list of all people in a Group within our smartsheet team. Example: I have a group that contains all users who are on our inspection…
-
Highlight expired dates
Hi - I'm not sure there is a way to accommodate this, but I thought I'd try here as my final resort. We have a date column that needs to be in a MM/DD/YYYY format. This is not an option in the drop-down list of date format and for some inexplicable reason Smartsheet things that all of the US only uses MM/DD/YY. I'd like to…