Forum Discussion

ae71181's avatar
ae71181
Copper Contributor
Jun 20, 2020

Is My Sharepoint Formula Too Long?

Hello,

I am a trying to enter a formula for a calculated column and I think it is structured correctly but I keep on getting an error message. It is a long formula. Is it possible that it is too long? Does Sharepoint have a limit for formula length?

Thanks!

admin

2 Replies

  • RobElliott's avatar
    RobElliott
    Silver Contributor
    Jun 21, 2020

    ae71181 you've not said how long your formula is but you are likely to hit problems if it is more than 1024 characters. You could probably overcome this by using a calculation in Power Apps.

     

    Rob
    Los Gallardos
    Microsoft Power Automate Community Super User

    • ae71181's avatar
      ae71181
      Copper Contributor
      Jun 21, 2020

      RobElliott Thank you. My formula is over 1024 characters so that's probably it.

       

      I am doing this for my work and I don't think they have Power Apps so I don't think I can use that.

       

      Can you look at my formula and suggest how I can shorten it?

       

      Basically I am trying to create a column that pulls a value from a 5x5 matrix based on inputs from 2 other columns. The 2 other columns (Likelihood2 and Consequence2) point to the location in the matrix.

       

      The matrix is as follows

      [11 16 20 23 25]

      [7 12 17 21 24]

      [4 8 13 18 22]

      [2 5 9 14 19]

      [1 3 6 10 15]

       

      I have attached my formula.

      Thank you.

Resources