Sign in to join the conversation:
Concerning the current limit of 25,000 total cross-sheet references per sheet - is there an easy way to determine how many are currently being used on any given sheet?
Thanks!
Hello,
There currently isn't a built in functionality that counts the number of cells in a cross-sheet reference. When you have a moment, please submit a Product Enhancement Request to let our Product team know that you'd like to have this functionality in Smartsheet.
I need assistance with creating a calculation. I have a list of people on one sheet that has their names and rate of pay. The person fills in a form and enters their hours (form is the Contractor Pay Summary sheet). I need the one sheet to look at the other and pull in the rate of pay for each user. Contractor Sheet This…
I am working on a column formula that won't generate a syntax error due to the first-row data entries. The goal of this sheet is to document and calculate changes in counts from a one month to another. A form will be used for data entry, and I have the form set up to put new entries at the bottom. The formula in the…
I created a master sheet that will list all projects for a department. We will also have a planning sheet for each project in the master sheet, created by copying one of four templates (based on the project type). Each of the four templates will have columns set up and a hierarchy of rows based on phases, workstreams,…
