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.

LEN() command in an Intake Form

Am I able to show a field on my Intake Form based on a column length. I have the following working on the sheet column =IF(LEN([Short Description]@row) > 15, "Too many characters", "") but I would like another field to show if the Short Description has a length greater than 15. I have a field called Validation Check that I plan to place a default value.

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