# Google Sheets formula within make.com

**URL:** <https://community.make.com/t/google-sheets-formula-within-make-com/54303>\
**Category:** Questions\
**Tags:** google-sheets\
**Created:** [September 7, 2024, 9:56am UTC](https://community.make.com/t/google-sheets-formula-within-make-com/54303 "2024-09-07T09:56:49Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Jim2](https://avatars.discourse-cdn.com/v4/letter/j/ba8739/32.png) [@Jim2](https://community.make.com/u/Jim2)\
**Post date:** [September 7, 2024, 9:56am UTC](https://community.make.com/t/google-sheets-formula-within-make-com/54303/1 "2024-09-07T09:56:49Z")

</div>

I’m facing an issue with a formula I’ve set up in Google Sheets:  
`=IF(ISNUMBER(FIND(",", INDIRECT("J" & ROW()))), SPLIT(INDIRECT("J" & ROW()), ","), INDIRECT("J" & ROW()))`  
It works perfectly within Google Sheets, but when I use the ‘Update a Row’ action in [Make.com](http://Make.com), the formula gets overwritten. I tried passing the formula directly into the field, but it seems [Make.com](http://Make.com) treats it as plain text rather than executing it as a formula. Is there a way to replicate or handle this formula directly within [Make.com](http://Make.com)?

---

<div class="post-metadata">

**Author:** ![Mr.Make](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/mr.make/32/93066_2.png) [@Mr.Make](https://community.make.com/u/Mr.Make)\
**Post date:** [September 9, 2024, 1:27pm UTC](https://community.make.com/t/google-sheets-formula-within-make-com/54303/3 "2024-09-09T13:27:07Z")

</div>

> [@Jim2](#):
>
> It works perfectly within Google Sheets, but when I use the ‘Update a Row’ action in [Make.com](http://Make.com), the formula gets overwritten. I tried passing the formula directly into the field, but it seems [Make.com](http://Make.com) treats it as plain text rather than executing it as a formula. Is there a way to replicate or handle this formula directly within [Make.com](http://Make.com)?

I don’t believe you can use a google sheets formula within the google sheets module. You need to use Make functions within MAKE.

You can use the raw J in the row and update it and have a formula in row K that looks at J and is blank if J is blank.

---

<div class="post-metadata">

**Author:** ![LinkYourTech](https://avatars.discourse-cdn.com/v4/letter/l/ba8739/32.png) [@LinkYourTech](https://community.make.com/u/LinkYourTech)\
**Post date:** [September 10, 2024, 2:19am UTC](https://community.make.com/t/google-sheets-formula-within-make-com/54303/4 "2024-09-10T02:19:48Z")

</div>

Did you select unformatted as yes?

---

<div class="post-metadata">

**Author:** ![Jim2](https://avatars.discourse-cdn.com/v4/letter/j/ba8739/32.png) [@Jim2](https://community.make.com/u/Jim2)\
**Post date:** [September 10, 2024, 10:23am UTC](https://community.make.com/t/google-sheets-formula-within-make-com/54303/5 "2024-09-10T10:23:38Z")

</div>

No I didnt use the advanced settings meaning I used value render option: Formatted value and Date and time Render Option Formatted String. Default settings

---

<div class="post-metadata">

**Author:** ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)\
**Post date:** [December 9, 2024, 11:27am UTC](https://community.make.com/t/google-sheets-formula-within-make-com/54303/6 "2024-12-09T11:27:07Z")

</div>