Sign in to join the conversation:
Hello,
I am receiving an error window stating that the sheet has reached the max number of different cross-sheet references. Would someone be able to provide more insight on max level of cross-sheet references?
Thank you
Hi OBR,
Previously discussed here: https://community.smartsheet.com/discussion/maximum-number-cross-sheet-references-sheet
There are 2 relevant limits for cross-sheet formulas:
Additional information about cross-sheet formulas is in our support article.
Daniel, I have to say I'm not very impressed with the limits or the fact that the support article has still not been updated to highlight the 100 cross-sheet reference limitation.
It couldn't take more than 5 minutes for someone to amend the article to include:
Almost 2 weeks later and still no update to the support article. Someone has to be accountable for these articles being kept up to date. Really poor form guys.
I have forwarded this post to someone that I believe cares (and works at Smartsheet)
Craig
Thanks Chris for checking in. I thought I responded to your earlier post, but it looks like it may not have posted for some reason -- apologies.
The help article is now updated. For context: our support team tracks and reviews content update requests at regular intervals and updates content in a way that ensures consistency across all our articles. This is why updates typically don't occur right away. I agree that 2 weeks is a bit long.
Thanks for your patience, and please keep the feedback coming.
Thanks Craig
I have created a approval workflow for two forms. Some information needs to be pre-populated from form 1 into form 2. Can I write a code in the url link in form 2 to have the information appear on the form?
Hi,
Not sure I follow!
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@getdone.se)
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
I'm receiving this message every time I try to open my sheets. I'm the only admin user. I have already performed proper troubleshooting, such as clearing the cache, logging in incognito, and logging out and back in, but the issue remains unresolved. It's been a few days, and I'm unable to track our projects and this…
I’ve created an automation that generates a document and forwards it to the individual specified in a cell. The line item also has several additional attachments associated with it. Is there a way to include those attachments with the generated document?
I have an automation set up that copies a row to another sheet each day. The automation itself works correctly, but the problem is that it copies the formulas rather than the values, which causes the formulas to break and return errors. How can I configure it to copy only the values instead of the formulas?
