On sharepoint online, for a custom list that contains single line of texts columns, i'm trying a simple calculated formula.
This fails with SharePoint online error "formula contains errors"
if i try the following:
So if i put any IF then it fails. obviously i need something more complex, as a 12 nested if or and.. but if this basic doesn't work then i can't advance.