Is it possible to copy and paste rows within in a single sheet with smartsheet api? I am using python.
When I try the following (using the same sheet id)
response = smartsheet_client.Sheets.copy_rows(
<MySheetID>,
smartsheet.models.CopyOrMoveRowDirective({
'row_ids': [<MyRowID>],
'to': smartsheet.models.CopyOrMoveRowDestination({
'sheet_id': <MySheetID>
})
})
)
I get the following error "Cannot copy or move row(s) within the same sheet."