In ColE, I want to return a count of the number of items in ColD. This is zapped in from my CRM, and at the moment this is a manual process. I would like to automate the process so that I can send the count (colD) back to my CRM.
The correct formula is shown in excel, but I am struggling with the Zapier format options. I have gone through various text formatter options, but keep getting 'syntax error’ with the below:
I am wondering how I get Zapier to specifically supply the cell reference (i.e, D2) instead of the cell value (the string value). I may be way off the mark here, but I feel it is close to working!
Any help or guidance or discussion is much appreciated.