Maximum characters allowed in a formula cell

jmo

Hi team - wondering if anyone can confirm that the maximum characters allowed in a cell is 4000 characters?

I have a super complicated formula that has tons of "NOT(CONTAIN)" for specific people and it exceed 4000 characters:

The long formula actually looks like this but Smartsheet won't take it all - cut off in BOLD:

=COUNTIFS({Agreements out for Approval (C H M) main row}, 1, {Agreements out for Approval (C H M) Created}, IFERROR(MONTH(@cell), 0) = 10, {Agreements out for Approval (C H M) division by}, NOT(CONTAINS("general counsel", @cell)), {Agreements out for Approval (C H M) C/H/M incorrec}, 1, {Agreements out for Approval (C H M) authors}, NOT(CONTAINS("gsd invalid request", @cell)), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("73616.2", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("73617.1", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("81069", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("81139", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("81231", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("81259", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("81285", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("81322", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("81356", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("81359", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("81406", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("81478", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("81506", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("81532", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("81548", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("81605", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("81661", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("82713", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("82780", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("82885", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("82888", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("83122", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("83192.3", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("83211", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("83220", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("83266", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("83310", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("83355", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("99703", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("99924", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("99941", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("100793.1", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("100898.1", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("104652.1", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("104779", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("104933.1", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("105214", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("107583", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("107738", @cell))), {Agreements out for Approval (Source Data) Agree #}, (NOT(CONTAINS("107946", @cell))), {Agreements out for Approval (C H M L) Low incorrec}, 1, {Agreements out for Approval (source data) authors}, NOT(CONTAINS("Andrea Cox", @cell)), {Agreements out for Approval (source data) authors}, NOT(CONTAINS("Victoria Roque", @cell)), {Agreements out for Approval (source data) authors}, NOT(CONTAINS("Zelda Fross", @cell)), {Agreements out for Approval (source data) authors}, NOT(CONTAINS("Jennifer Arashnia", @cell)), {Agreements out for Approval (source data) authors}, NOT(CONTAINS("GSD Invalid request", @cell)), {Agreements out for Approval (source data) authors}, NOT(CONTAINS("Zachary Rome", @cell)), {Agreements out for Approval (source data) authors}, NOT(CONTAINS("Barbara Martinez", @cell)), {Agreements out for Approval (source data) authors}, NOT(CONTAINS("Vanessa Martinez", @cell)), {Agreements out for Approval (source data) authors}, NOT(CONTAINS("Veronica Parker", @cell)), {Agreements out for Approval (source data) authors}, NOT(CONTAINS("Maria Ibarra", @cell)), {Agreements out for Approval (source data) authors}, NOT(CONTAINS("Noemy Diosdado", @cell))

Is there a simpler way to NOT include specific "authors" by name?

Andrée Starå

Hi @jmoser

Yes, the character limit is 4000.

As a workaround you could maybe change the name of the cross-sheet reference to something shorter.

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @jmoser

Yes, the character limit is 4000.

As a workaround you could maybe change the name of the cross-sheet reference to something shorter.

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

jmo

That is a really good idea, @Andrée Starå - that will really save a bunch of characters!

Jeff

Andrée Starå

@jmoser

Thanks!

You're more than welcome!