Zapier and Formulas
I'm trying to use Zapier to input formulas into a Text/Number column (which does support formulas) and it comes over as a text string: '=INDEX(PARENT(), 1)
I'm using Control Center which creates new rows on a sheet via cell links, but the auto-fill function doesn't seem to work when the new rows are added here; hence trying to use Zapier as a workaround.
Any idea why this is?
Comments
-
Hi Rochelle,
I believe Zapier will only update the "value" property of the cell and not the "formula" property. You might be able to get the results you're looking for with an HTTP call. See minute 12:45 of this video for an example: https://help.smartsheet.com/learning-track/user-education-beginner/smartsheet-has-api-what-and-why-would-i-want-use-it
I'd also suggest submitting a Product Enhancement Request for our Zapier integration.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!