Conditional formatting system as in Excel
Conditional formatting system as in Excel
For Sharepoint to be customized easily for power users or advanced users without coding experience, JSON is a nightmare
Users should have the choice to opt for graphic (excel type) or coding system to format each column


We just rolled out a Column formatting template – “Conditional Formatting”, that allows users to create if/else/then statements.
1 comment
Comments are closed-
Django Lohn commented
I saw If statements are made more Excel like within the JSON: "title": "=if([$FlowStatusText] == 'New','Wait a minute','Go to page of '+@currentField)"
Though this is a big improvement compared to older ? / Operands / Operators expressions --> there is no documentation if other Excel like expressions are now supported.
Like Max / Min / Replace / Substitute etc...