1

What I'm attempting to do is create a calculated column that displays an image's aspect ratio based on the computed columns Picture Width and Picture Height.

This video (https://youtu.be/b-W64DHKO8o?t=99) does exactly what I'm looking for in Excel, but when I tried using the GCD function in SharePoint, it sent me to a technical error page.

Did I format it incorrectly, or is this even possible to do?

Here's the formula I tried:

=GCD([Picture Width],[Picture Height])
4
  • GCD function is not available in SharePoint. Functions in excel and SharePoint are different. Jun 1, 2023 at 17:34
  • 1
    Got it, thanks!
    – Xander
    Jun 6, 2023 at 20:34
  • You're welcome. I have added an answer below with some explanation and link to documentation showing available functions in SharePoint formulas. Jun 13, 2023 at 5:41
  • Please accept my below response as an Answer if it helped you in any way & it will help others with similar question in future to find the correct answer easily. Jun 13, 2023 at 5:42

1 Answer 1

0

You are receiving this SharePoint technical page error because GCD function in Excel formulas is not supported by SharePoint calculated column formulas.

You can find all available functions in SharePoint calculated column formulas in below Microsoft official documentation:

Examples of common formulas in lists

You will have to utilize the functions available in above documentation to achieve your requirements based on the business logic.

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.