Formula Issue

edited 12/09/19 in Formulas and Functions

Hi all,

would anyone let me know of any 'string' limitations in smart sheets when creating a formula?

I have attempted the below in every conceivable possible way and I can only think that the formula is technically too long.

I am trying to complete the below:


  • GDI End date before today and complete <> 100%
  • OR
  • GDHV Portadown End date before today and complete <> 100%

(See image below)


I then need to add all the other companies into the formula I have going out to the right.


Thanks a million,



Screenshot (185).png



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!