SharePoint list conditional formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1729704%22%20slang%3D%22en-US%22%3ESharePoint%20list%20conditional%20formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1729704%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20read%20the%20article%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Fdev%2Fdeclarative-customization%2Flist-form-conditional-show-hide%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3EShow%20or%20hide%20columns%20in%20a%20list%20or%20library%20form%3C%2FA%3E%20plenty%20of%20times%20so%20I%20know%20how%20to%20make%20a%20column%20visible%20if%20a%20specific%20choice%20is%20selected%20e.g.%20%22Show%20if%20column%20Title%20equals%20A%22%20would%20be%20written%20as...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22lia-align-center%22%3E%3CSTRONG%3E%3D%5B%24Title%5D%3D%3D'A'%3C%2FSTRONG%3E%3C%2FP%3E%3CP%20class%3D%22lia-align-center%22%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20write%20one%20such%20formula%20to%20say%20%22Show%20if%20column%20Title%20starts%20with%20A%22%20instead%3F%20Also%2C%20is%20there%20a%20more%20detailed%20guide%20to%20writing%20these%20formulas%20out%20there%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22ConditionalFormula.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F223077i7AC10F3607F19285%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22ConditionalFormula.png%22%20alt%3D%22ConditionalFormula.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1729704%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

I've read the article Show or hide columns in a list or library form plenty of times so I know how to make a column visible if a specific choice is selected e.g. "Show if column Title equals A" would be written as...

 

=[$Title]=='A'

 

Is it possible to write one such formula to say "Show if column Title starts with A" instead? Also, is there a more detailed guide to writing these formulas out there?

 

ConditionalFormula.png

0 Replies