Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions