-
Rows could not be added to the destination sheet because it did not have enough cells remaining
I have a blank sheet that serves as a "backup" for our main sheet. We have an automation that copies the data from the source sheet to the to the backup sheet once a week. To work around the fact that smartsheet doesn't have a built in way to delete data, we also have a blank excel file that "uploads" to the backup sheet…
-
error with only one sheet
Why I am getting this error since morn ing
-
How do I avoid the cross sheet cell reference limit of 100,000?
I have several formulas that are critical to one of my dashboards. They reference a master sheet that grows daily in number of rows. I end up getting the cross sheet cell reference limit warning about every 15 days. Is there some way to easily mitigate this? I'd like to avoid reducing the size of the master sheet so…
-
Max out Cross sheet reference ?
I have an error message "unable to create cross sheet reference because this sheet already contains the maximum number of different cross sheet references." How to resolve this issue? I already deleted many rows to reduce the cross reference but didn't work.
-
Remove or Increase Cross Sheet Reference Limitations
Please consider removing or increasing cross-sheet reference limitations. I recently built a solution that would require me to manage 3-4 sheets each month for monthly audit results tracking from Joint Commission. I spent weeks building and testing and at the end had to add more questions (total of about 125 to the form.…
-
Merged: Forms Set to Expire
This discussion has been merged.
-
Merging Rows from Duplicate Speakers
I have a sheet that I am using to collect COI from faculty, but our faculty often are involved in multiple activities that often leads to them inputting several COI entries. I've managed to create a duplicate checker to see which faculty members have entered their COI twice, but that doesn't necessarily solve my issue of…
-
Sheet Name links not taking user to correct sheet row
Hi there, since yesterday I have noticed that the Sheet Name column links in reports are not taking the user the correct row in the source sheet, as they have always done. There does not seem to be a pattern, sometimes it takes the report user to the top of the source sheet, or to a random row, or the odd time to the…
-
User clicks Sheet Name in report, takes them to incorrect row on source sheet
The problem: We built a report that pulls information from 6 other sheets in the workspace. When you click on the source sheet hyperlink in our "Sheet Name" column, the system is supposed to take you to that sheet, as well as to the specific row that the report was referencing. While this works for myself and most of our…
-
How to make a Static Sheet Form for Multiple Cells?
Basically I have a questionnaire template for projects that I created that I need as a sheet to allow people to enter scoring rubrics and comments into a master sheet, but the projects need their own static sheet in each cell of the master sheet. Is there an easy way of doing this without having to create a million copies…