If the Smartsheet connected to the Zap is currently active, new rows added to a Smartsheet won't trigger the Zap.
To trigger from these newly added rows of data, you will either have to:
- Choose another sheet to make the current sheet inactive
- Close the Active sheet
You may be receiving emails warning that your Zap is trying to trigger off too many changes. If this is the case, and you're using the "Updated Row" trigger, ensure that if you add rows to the sheet that you add them to the very bottom of the sheet and not the top or in the middle.
If you add anywhere but the very bottom, every row below it will change its row number thus triggering a change en masse.
"There was no data available to create or update a row in Smartsheet. Either the Trigger did not provide any data, or none of the Action fields were mapped to Trigger fields. Please check your configuration."
The "Add Row to Spreadsheet" and "New Row Update" Actions require that at least one field be filled out in the Zap. If you encountered this error while using one of these Actions, it is possible that during the configuration of the Zap none of the Action fields were mapped (by selecting a dropdown option) or manually filled with values. Alternatively, the Trigger may not have provided any data.
was not found."
A Smartsheet column used in your Zap may have been deleted from the sheet. You need to edit the Action portion of your Zap to remove any data or mapping from the column in question.
There isn't currently a way to match file attachments or discussions for Smartsheet Triggers or Actions.
There isn't currently a way for Smartsheet actions to receive files provided by certain Zapier file-enabled triggers (Gmail and others).
Columns that are locked based on your sharing permission level won't be displayed.
Date values provided by Smartsheet are not time-zone specific, so using Actions and Triggers that involve date values may not display the results you expect. You can use the Formatter app to modify dates and times as needed.
If you wantSmartsheet has two ID fields, one called
ID and the other called
OriginalID. You'll want to use the
Original ID field for this zap. It should look like this:
Trigger sample results contains a lot of
No Sample Data values
This happens when data has not been "Saved" in a Smartsheet row yet. To fix, enter some data in a row of your Smartsheet, then click the "Save" icon in top-left of the sheet.
Smartsheet occasionally sends out messages regarding compatibility with their API. Zapier supports up to TLS 1.2, so we are compatible with Smartsheet's API!
I'm getting the error message of "Value is not supported for this column type. Use objectValue instead."
In your Smartsheet, make sure all the columns have "Not allow multiple contacts per cell" unticked. As it's not possible supported to add more than 1 contact record to a specific cell.