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 lon...
admin
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