1

I have a calculated column in SharePoint at the moment, it uses a formula to pull in a month name, number of holidays in the that month and then multiplied by 3. The formula I am using is:

IF([Month]=“August”,[Number of Days]*3)

This works fine, however if I also want to calculate month of June in same formula to give combined figure for August and June, can anyone help with formula I should use please?

10
  • Do you have the "figure" or no of days for both august month and june month in same list item/row or different list items/rows? Commented Sep 11, 2023 at 8:24
  • Yes both in same list @GaneshSanap-MicrosoftMVP
    – user107779
    Commented Sep 11, 2023 at 10:38
  • I am not asking about same list. I am asking about same item/row/record. Commented Sep 11, 2023 at 10:39
  • My apologies. Yes same item/row/record @GaneshSanap-MicrosoftMVP
    – user107779
    Commented Sep 11, 2023 at 10:41
  • Are there two different columns for August and June? Can you add more details how you want the combined figure? explain with some examples & data to understand it properly, thanks! Commented Sep 11, 2023 at 10:42

1 Answer 1

0

As you are creating/adding new list item/row for each month (For example: June & August), you will not be able to get the combined figure using SharePoint calculated column.

SharePoint calculated column formulas cannot read values from different list items/rows, it can read column values from same item/row only - This is by design limitation of SharePoint calculated columns.

You cannot reference a value in a row other than the current row.

Microsoft Documentation Source: Introduction to SharePoint formulas and functions

You may need to use another way for your requirements like using scheduled (daily, etc.) Power automate flow to read items from SharePoint list and get the combined figure OR customize the list forms using Power Apps and calculate the combined figure using Power Apps formula/functions while saving/updating list items.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.