Fix broken Make.com scenario - Monday.com to Google Sheets (formatNumber error)

Posted 4 weeks ago

Worldwide

Summary

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
  • Expert
    Experience Level
  • Remote Job
  • One-time project
    Project Type
Skills and Expertise
Mandatory skills
Make.com
Automation
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
Member since Jun 21, 2023
  • United Kingdom
    London3:16 PM
  • $12K total spent
    121 hires, 28 active
  • 50 hours

Explore similar jobs on Upwork

Job Aggregation and Dashboard CreationHourly‐ Posted 8 months ago
Automation
Data Scraping
Data Extraction
API
UI/UX Prototyping
Web Scraping
Zoho Creator

How it works

  • Post a job icon
    Create your free profile
    Highlight your skills and experience, show your portfolio, and set your ideal pay rate.
  • Talent comes to you icon
    Work the way you want
    Apply for jobs, create easy-to-by projects, or access exclusive opportunities that come to you.
  • Payment simplified icon
    Get paid securely
    From contract to payment, we help you work safely and get paid securely.
Want to get started? Create a profile

About Upwork

  • Rating is 4.9 out of 5.
    4.9/5
    (Average rating of clients by professionals)
  • G2 2021
    #1 freelance platform
  • 49,000+
    Signed contract every week
  • $2.3B
    Freelancers 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

  • Microsoft Logo
  • Airbnb Logo
  • Bissell Logo
  • GoDaddy Logo