Skip to main content

New answers tagged

0 votes
Accepted

Calculated column in MS Lists not returning any output?

Your formula works perfectly for me. What are your column types? Your formula wants your Impact and Likelihood columns to be numbers, not text. If your columns are text columns, the solution is to ...
user79408's user avatar
  • 1,055
0 votes

Exporting List View to Excel Includes Hidden Source Fields Used in Calculated Columns

Instead of using the "Export to Excel" command, start in Excel and use Power Query (Get and Transform on the Data ribbon). With Power Query, you can get data from a SharePoint list. Using ...
teylyn's user avatar
  • 9,044
1 vote

Calculated Column IF statement limit?

This is a known limitation with SharePoint calculated column formulas. You can use maximum 19 nested IF functions in calculated column formula. If you have more than 19 nested IF functions/conditions, ...
Ganesh Sanap - MVP's user avatar
0 votes

How to calculate difference in the same column

If I understood your question correctly, I think you are trying to create a calculated column based on same column (counters) values from 2 different list items/rows for same "Athletes name"....
Ganesh Sanap - MVP's user avatar
0 votes

IF(OR(ISNUMBER(FIND( Issues nested SharePoint library

You can use SharePoint calculated column formula like below for your requirements: =IF( OR( ISNUMBER(FIND("Townfield",[Title])), ISNUMBER(FIND("townfield",[...
Ganesh Sanap - MVP's user avatar
0 votes
Accepted

IF(OR(ISNUMBER(FIND( Issues nested SharePoint library

As the error suggests, you have some issues with your syntax. In my opinion, this can happen really easily, due to how the SharePoint calculated column formula input works. I'd suggest using a tool ...
user79408's user avatar
  • 1,055

Top 50 recent answers are included