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.
Hello, We created a dashboard last year that pulled data from the week number but now that it's a new year, the data isn't pulling correctly. We added a year column, but haven't quite figured out how to do it correctly. Any help? Does this look correct? =COUNTIFS(WEEKNUMBER({PrintProductIntake-Week#}, [Primary Column]@row…
Hi, I created a formula that derives a value-based date range but if the date field is blank, I receive an INVALID DATE TYPE comment in that specific row. I read a few comments online that says if I apply the IFERROR operator, it will remove this error, but it returns “Incorrect Argument Set”. Here’s a sample of my…
If I am trying to create a metric formula to count how many rows were created today, created yesterday, created 3 days ago etc… by using the auto "Created Date" column. The current formula I am using is not properly adding them correctly =COUNTIFS({Ticket Tracker Range 1}, "COUNTING" , {Ticket Tracker Range 3}, =TODAY(-1))…
