# Maximum characters allowed in a formula cell

✭✭✭✭✭✭

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?

• ✭✭✭✭✭✭

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

Jeff

• ✭✭✭✭✭✭

Thanks!

You're more than welcome!

SMARTSHEET EXPERT CONSULTANT & PARTNER

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

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!