User Profile
mcowen
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
SP Online: Using Boolean in IF Statements
Good day. I'm having an issue with getting a boolean statement working in an IF statement. Platform: SharePoint Online (Office 365 Business Premium) List: Modern List Issue: I have a list that contains several Yes/No columns (defined as Y/N). Other columns have numbers and are defined as Number. I would like a new calculated column to show me the number from one column if Yes and the amount from a different column if No. Eventually, I would like to make several tests, ie.If column 5 is Yes AND column 6 is No THEN use column 2 amount...But let's try to walk before we can run 🙂 Here is the formula that refuses to work (syntax error) : =IF(ReportVF=TRUE, Previsionnel,0) ReportVF is Yes/No Column Previsionnel is a Number Column I've tried with and without [] around column names. I've tried 1 instead of TRUE. I've tried "True". I've tried ; instead of , separators ...Nothing works 😢 Any help would be most welcome. It should be simple, but apparently it's not with SharePoint.Solved1.7KViews0likes2Comments
Groups
Recent Blog Articles
No content to show