Sign in to join the conversation:
Is there a way to increase formula reference data. The default restriction is 25k cells and i'm exceeding this
Hi,
Unfortunately, it's not possible at the moment to increase the limit, but it's an excellent idea!
Please submit an Enhancement Request when you have a moment.
There might be a way to structure the solution, so it doesn't hit the limit.
I'm also almost sure that Smartsheet is working on increasing the limits.
I hope that helps!
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant / CEO @ WORK BOLD
Hi All, I just want to pull the title 'BSR Tracker' in column 33 Please note there's another Blue bar in the same tracker i.e. two levels at ancestor = 0 so i just want to pull that title in. currently the formula im using but doesn't seem to be working is: =IF(COUNT(ANCESTORS([Site Name]@row)) = 0, "",…
Hi! I have a formula that indicates the number of days since the last update. I have 2 different projects that were updated on the same day, but one is showing 1 day since the last update and one shows -1 since last update. The only difference is that the 2nd one was submitted after 5 pm Pacific Time. It's not possible to…
I am needing to compare an active employee roster (Excel) to a list of users for different platforms (smartsheets and excel). This will need to be able to be done quarterly and show which names are not on each list.