Welcome!

Formula reference data exceeding 25k cells

Is there a way to increase formula reference data. The default restriction is 25k cells and i'm exceeding this

Formulas

Hi,

Unfortunately, it's not possible at the moment to increase the limit, but it's an excellent idea!

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

Workaround for =HYPERLINK
Each row has a unique ID and I use this to generate two different hyperlinks in excel with this =HYPERLINK(CONCAT("http://www.XXXXX/",A3),"URL") Is there a workaround in Smartsheets to do similar?
Set a value on one sheet if that sheet's row ID exists on another sheet with a certain status
I have Idea IDs that appear on two different sheets (sheet A, sheet B), and I have a column on sheet B called "Update needed?" Sheet A also has an Idea status column. I need a column formula for sheet B's "update needed" to be set to Yes if sheet A's Idea ID=sheet B's Idea ID for that row AND sheet A's status is "Not…
Range settings
=SUMIF({Stores Daily Log Range 8}, "1000000456", {Stores Daily Log Range 9}) Hi I am adding figures from the above sheet to another sheet using criterias. everything works until I add another line in the log then the Range does not automatically pick up the new line. Is there a way to do this please.