Adding MTD Spend & Pacing to Flexible Budgets

[BR]

I am currently using the Flexible Budgets script but I want to make some tweaks within the spreadsheet. I am wanting to add a column for MTD Spend, so I can get a pacing % based off the total budget per campaign. I am achieving this by using the following array formula "=ARRAYFORMULA({{"MTD Spend"};IF($C5:$C="",,VLOOKUP($C5:$C, 'MTY Data Import'!$C:$E, 3, false))})" from another tab to get the MTD Spend. When I do this, I get the following account selector error "Exception: One of the conditions in the query is invalid. (file Code.gs, line 40)". But if I manually enter the amounts, I do not get this error. Thoughts? Thank you. 

[Google Ads Scripts Forum Advisor Prod]

Hi BR,

Thank you for reaching out to us.

So I can further investigate the issue, could you provide the following information via Reply privately to author?

• CID
• script name
• access to the spreadsheet

Regards,
Hiroyuki
Google Ads Scripts Team

ref:_00D1U1174p._5001UCaJbx:ref

[BR]

Hi Hiroyuki, just circling back to this for any updates. I know last time you responded through private message I never received it. Just seeing if that was the case this time as well. Thanks for your help.