Add more Rows to a Sheet

Here you will learn how to add more rows to Sheet Table or Dashboard

Understanding How to Add More Rows to a Sheet

🇬🇧

After using the iDealOps system for a while, you may need to add more rows—either to continue entering data into your HelpCenter or to expand the dashboard for greater detail. Since Google’s native functionality doesn't fully meet the system’s requirements, we've developed a safe and reliable method for adding rows. To ensure you follow the correct process, we’ve prepared a tutorial that guides you through adding rows to the dashboards or sheets as needed.

🇪🇸

How to use it like a Pro

🇬🇧

1. First, click the top section where the “Add More Rows” option appears. The system will then prompt you to grant the necessary permissions to proceed.

🚨READ THIS TO KNOW HOW TO GRANT PERMISSIONS PROPERLY:

Grant Access to run Script

1. ⚠️ Only if you have already granted the necessary permissions, click on “Add More Rows” again, then select “Add More Rows to a Sheet.”

1. Once you click on the “Add More Rows to a Sheet” option, a pop-up will appear. Click the dropdown menu and select the sheet you want to add more rows to.

1. Continuing with our tutorial, simply select the sheet and add rows. For this example, we’ll use the Calls_Sales Dashboard.

   As you can see, when applying the All Bookings filter—which displays all booked sales calls—an error appears due to an insufficient number of rows. This is a perfect example of when additional rows are needed.

1. So, by choosing to add more rows to the Calls_Sales Dashboard and clicking Submit Changes, you’ll resolve the issue and ensure the data displays correctly.

   1. It could take 3-5 minutes for the rows to be added ⚠️

   
2. Voila! The filter now works correctly because there’s enough space for the data to display as intended.

And that’s how easy it is to add more rows to a sheet. Thanks for reading!

🇪🇸

⚠️IImportant Considerations

🇬🇧

• If you have any Overdue NOT_Filled Errors in any of your input tables, you won’t be able to add more rows using this functionality. To learn more about this type of error, please click here.

  
• The system does not let you choose how many rows you want to add. It automatically adds 50 rows for Dashboards and 200 rows for Input Tables every time you follow this process.

• It could take 3-5 minutes for the rows to be added ⚠️

• Always make sure you have granted permissions properly to avoid unexpected errors.

🇪🇸