-
error with only one sheet
Why I am getting this error since morn ing
-
Master Project Plan
I have a massive project that spans across multiple regions. I want to segregate my plan into region sheets so when I update each individual plan the master plan will be updated. How can I do this?
-
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.…
-
Can automated email come from a specific email address?
We created a tracker for the Records Management team and need all emails coming from the tracker to come from the email address associated with the team. Is there a way to have all emails come from this specific email? I see options for the owner or from general smartsheet but not an option to have it come from a different…
-
Forms Set to Expire
It would be beneficial if we could set a expiration time on forms created for a workspace. We are using a form as an order form and sending the link out to capture order details, the customer only wants to offer this opportunity for 1 day. So we will have to delete the form but would be nice to just set a time period for…
-
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…
-
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…
-
Multiple Line Entries with one Form Submission
It would be great feature if one form could be used to fill in multiple lines/rows on a sheet. This would be super useful for my team. As of now, form entries can only create singular row entries on sheets.