Share via

Calculated Column in Sharepoint Lists

Anonymous
2022-10-13T08:58:47+00:00

Hello,

I am struggling to transfer the attached formula from excel to SP lists calculated column... does anyone know if this is too complicated for Lists to recognise?

Many thanks!

Microsoft 365 and Office | SharePoint | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-10-13T09:59:01+00:00

    Dear Alex Dugan,

    Good day! Thank you for posting to Microsoft Community. We are happy to help you.

    As per your description, please let us cooperate and please don’t worry, we can work together to narrow down and resolve the situation.

    As you know that, in SharePoint list calculated column we cannot use cell number or ranges. For example: A39(in Excel cell).

    You can use same formula but just replace cell number to SharePoint related created column name. However, based on my test, In SharePoint online list calculated column, EOMONTH is not working and not available as a function.

    Image

    As a workaround you may use Microsoft Flow Power Automate trigger. For Flow trigger you may post in Microsoft Power Automate Community for expert assistance. This is a specific channel related with Power Automate Flow.

    The reason I ask you to post is that in Answers forum, we have limited resources and very little knowledge about Power Automate and in Microsoft Power Automate Community, you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction.

    Your understanding and patience will be highly appreciated. I hope that you are keeping safe and well!

    Sincerely, 

    Waqas Muhammad

    Was this answer helpful?

    0 comments