Fix broken Make.com scenario - Monday.com to Google Sheets (formatNumber error)
Worldwide
I have a Make.com scenario that runs monthly to build a sales dashboard in Google Sheets, pulling data from Monday.com. It ran fine for months and has now failed on the latest run with this error: "Failed to map 'values.5': Function 'formatNumber' finished with error! 'Infinity' is not a valid number or using unsuitable separator." I need someone to diagnose and fix it so the scenario runs cleanly again. Two things I want checked: 1. The formatNumber / Infinity error itself. This looks like a division-by-zero or an empty value feeding into a number calculation somewhere upstream. I need the root cause found and handled properly (graceful fallback for zero or empty values), not just patched for this one run. 2. Whether the recent Monday.com V1 to V2 module migration is the underlying trigger. Monday's V1 API was discontinued on 1 May 2026 and Make required all Monday modules to move to V2, with some field mappings changing (discontinued fields, "changed at" renamed to "updated at"). I likely did not complete this migration, and this is the first time the scenario has run since the cutoff. If V2 changes are causing a column to arrive empty and breaking the calculation, I need the modules migrated correctly and the mappings re-pointed. SCOPE: - Diagnose the failing scenario and identify the actual cause (formula, data, or V2 migration related) - Migrate any remaining Monday.com V1 modules to V2 and fix affected field mappings if relevant - Add proper handling so zero / empty values do not crash formatNumber in future - Test a full run end to end and confirm the dashboard populates correctly YOU SHOULD HAVE: - Strong Make.com experience, ideally with Monday.com modules specifically - Familiarity with the Monday V1 to V2 migration and the Module Migrator - Comfort debugging Make functions and mappings (formatNumber, number formatting, separators) BUDGET: $50 fixed fee. This is a quick diagnostic fix, not a rebuild. The scenario is small and the cause is already half-identified above. DELIVERABLE: A working scenario that completes a clean run, plus a short note on what the root cause was and what you changed. To apply: open your proposal by telling me what you think Infinity at formatNumber most likely indicates, so I know you've actually read this.
$50.00
Fixed-price- ExpertExperience Level
- Remote Job
- One-time projectProject Type
Skills and Expertise
Activity on this job
- Proposals:20 to 50
- Last viewed by client:4 weeks ago
- Hires:1
- Interviewing:1
- Invites sent:0
- Unanswered invites:0
About the client
- United KingdomLondon3:16 PM
- $12K total spent121 hires, 28 active
- 50 hours
Explore similar jobs on Upwork
How it works
Create your free profileHighlight your skills and experience, show your portfolio, and set your ideal pay rate.
Work the way you wantApply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
Get paid securelyFrom contract to payment, we help you work safely and get paid securely.
About Upwork
- 4.9/5(Average rating of clients by professionals)
- G2 2021#1 freelance platform
- 49,000+Signed contract every week
- $2.3BFreelancers earned on Upwork in 2020
Find the best freelance jobs
Growing your career is as easy as creating a free profile and finding work like this that fits your skills.
Trusted by