2 min to read Show Show or Hide column based on condition in SharePoint Online list.Show or Hide column based on condition in SharePoint Online listMicrosoft announced an updated feature that is shown or hide the column in the SharePoint list based on a value in another column by specifying the conditional formulas, this formula is made with equations. In this blog, we can see how to create this conditional equation and the outcomes of this equation. How to create a conditional formula?
Conditional formulas:Now lets consider the equation to perform the actions. The equation must start with = and followed with if condition, if the condition satisfies then it returns true this means it shows the column, else it returns false which makes the column to hide. For example:In our example, we are applying the formula in the column workpercentage. if the status value is completed then workpercentage need to be true, which means workpercentage needs to show up. Or else the workpercentage column will get hidden while editing. Choice column:This equation checks the choice column status is equal to completed Number column:This following formula check the number column workpercentage is less than or equal to 50 Arithmetic calculationsWe can also do the arithmetic calculation such as adding the two column and checking its sum. Date column:We can act with a date column(M/D/Y) Unsupported column types:Currently, they do not support the following column type
#Sharepoint Online Previous Post Next Post |