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.
=IF([Due Date]@row > TODAY(), IF(AND(Status@row = "In Progress", Status@row = "New", Status@row = "Not Started"), "Yes", "No"))) The goal is to flag items for escalation based on the due date and status. If the due date is in the past and the status of the risk or decision is in progress, not started, or new then I need to…
Hi - we are performing an audit and we need to take the data, and have the consumer validate that its accurate, and if not, identify the change required. What's the best way to tackle that? I was thinking a form but there could be lines and lines of data to validate; is it as simple as having them review the sheet for…
Ultimately, I need a good way to track if we are completing tasks on time based on our original estimates because we have users that estimate a task will take 5 days and when it takes 15 they just change the dates, and the project status still looks green, when is reality it is behind. I would like to have target start/end…
