Major Issue with Data Import using 'Prepare Data'

Major Issue with Data Import using 'Prepare Data'

The end goal for my project is to schedule booked capacity in my business by importing from my Project Manager database. The imported data will include the department, the job number, the estimated and actual hours for that job, and the projected start and end date for that job.

Now step 1 of this project is to first fill in the cells with blank dates for the start and end date columns for two reasons. One, because if the dataset has any blanks in a date column then ZOHO will kill all the data in the column, and Secondly because sometimes our PM’s just make mistakes and forget to enter a date, so a default for today is helpful.

When there is a blank date, I want to use the “Prepare Data” to replace the blank cells with the current date of the import. I have images below for what I did. When I do this, in the “Prepare Data” preview the dates look like they are coming out correct, in the case of the image attached all the 2/15/2022 were blanks before and properly now filling in with today’s date (As of import it was 2/15/2022), and the dates that were not blank are untouched. So in the Prepare Data Preview everything looks good.

Now when I go to the ACTUAL table that was imported (the darker images) you can see where I have highlighted examples of the problems for reference. The first problem is that it didn’t even import today’s date into the blank cells (2-15-2022), instead it imported a date two weeks old (2-1-2022) (See highlighted job 949334T). The second problem is that jobs that HAD dates in cells and were NOT blank have been overridden with the wrong date (See job 949336T)

It doesn’t make sense to me that the Prepare Data produces a COMPLETELY different result than the actual import.

Please assist. Thank you









    • Sticky Posts

    • What's New in Zoho Analytics - November 2025

      We're thrilled to announce a significant update focused on expanding your data connectivity, enhancing visualization capabilities, and delivering a more powerful, intuitive, and performant analytics experience. Here’s a look at what’s new. Explore What's

    • What's New in Zoho Analytics - October 2025

      Hello Users! We're are back with a fresh set of updates and enhancements to make data analysis faster and more insightful. Take a quick look at what’s new and see how these updates can power up your reports and dashboards. Explore What's New! Extreme

    • What’s New in Zoho Analytics – September 2025

      Hello Users!! In this month’s update, we’re raising the bar across multiple touchpoints, from how you bring in data, plan and track projects to how you design and brand your dashboards. We’ve added the all-new Gantt chart for project visualization, expanded

    • Announcing Agentic AI - Ask Zia!

      We are delighted to roll out the new agentic AI capabilities in Ask Zia, where every stage of the BI workflow is assisted by AI. With a human-in-the-loop approach, Ask Zia ensures that you’re in command of the decision, while AI handles the complexity.

    • Invitation-Based User Access in Zoho Analytics

      Hello everyone, We’re rolling out an important update on how users are added to your Zoho Analytics Organization and Workspaces. Previously, when admins added users, they were automatically added to the organization. Moving forward, to improve security