Validation item in Sharepoint

…this post was published on 2017 March 03.

How we can force users to fill a secondary line text if another column ( yes/no ) is checked as Yes

Suppose that , the Yes/No column with the name yesno, and as single line text column I created the column <<textcolumn>>

The formulat I propose is
=10*yesno+COUNTA(textcolumn)<>10


and the result is this one

 

This entry was posted in CalculatedColumn, Sharepoint, Sharepoint Online, Validation. Bookmark the permalink.