The SmartSheet integrations leave a lot to be desired. It could be improved by:
1. Allowing for an updated row trigger
2. grabbing the columns of a row as variables (on that trigger and any others)
3. Not requiring a list of columns, but instead grabbing them from the sheet and allowing the user to select which ones (or doing so automatically based on what the user picks in a later step
@mrisch - Your Smartsheet integration improvement requests were like you were reading my mind!
It would be great to have more control over the Smartsheet triggers and actions. One example, would be when a row is assigned to a user, the due date is added to that user's Outlook calendar.
This level of control would make this integration much more useful.
Would love to have the updated row functionality - I'd like to autogenerate a task in TFS based on one of my Smartsheets, but only after a certain status has been met, not on the creation of a new row.
Has anyone been able to use the "Add a discussion to a sheet" action? It fails every time for me. Missing a parameter or arguement or something.
I'd like to throw in the following functions:
Point 3 should be part of this as MVP...
I'd like to see an improvement to Insert Row where one of the results is "RowID" so that I can use it for adding a discussion or comment to a row. Its strange that the input for add discussion is RowID but you can only get RowNumber from outputs.
This is still a prevalent thing in 2020.
RowID should be an output of Insert Row. That's silly.