-
Guest access set to Edit, but cannot attach files to sheet.
I have a vendor that is helping our company with a deployment. We have given their PM access to our sheet as Edit cannot share, but when they try to add attachments to the sheet it comes up stating they do not have access to upload to that line. Why?
-
Using Multiple Sheets as Resource Allocation Tool. Allocations not updating based on date changes
Hello! I am trying to use sheets in a resource management type of way without the complexity. I have two sheets I am using. Sheet One: Holds all the resources. It includes allocations based on dates. Sheet Two: Displays summary of allocation. I would like sheet two to update the Total Percent Allocation for each person…
-
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
-
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?
-
System Admin: How to export a list of all Smartsheet assets across the account?
Hi everyone, I am trying to generate a report that lists all assets (Sheets, Dashboards, and Reports) created by users within the same Enterprise account. I have System Admin permissions, and so far I have tried the following: Navigated to Admin Center → User Roles and Reports → Generate reports Selected Sheet Access to…
-
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…