Formula Character Limit

Options

I am creating a large formula, when I add in another column, the formula stops working. Is there a character limit to a formula in a cell?

=IF(OR([Billing Schedule]@row = "", [Billing Launch Date]@row = "", [Steady State Date]@row = "", [# of Locs]@row = "", Biller@row = "", [Monthly Goal Standardization]@row = "", [Monthly Goal]@row = "", Status@row = "", [Goal to Fast/PM]@row = "", [Monthly Goal Date]@row = "", [BB Window]@row = "", [Billing Year Month]@row = "", [Sent to Fast vs. Returned to Billing]@row = "", [Launch to First Bill Sent]@row=””, [Actual Goal Completion Date]@row = "", [Core Sox Audit Completion Date]@row = "", [Sox Audit Completion Date]@row = "", [Actual to Fast Date]@row = "", [Date Review Returned to Billing from FAST]@row = "", [Date Review Returned Back to Billing from Launch]@row = "", [Release Date]@row = ""), "", "Complete")

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!