Is My Sharepoint Formula Too Long?

%3CLINGO-SUB%20id%3D%22lingo-sub-1479076%22%20slang%3D%22en-US%22%3EIs%20My%20Sharepoint%20Formula%20Too%20Long%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1479076%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI%20am%20a%20trying%20to%20enter%20a%20formula%20for%20a%20calculated%20column%20and%20I%20think%20it%20is%20structured%20correctly%20but%20I%20keep%20on%20getting%20an%20error%20message.%20It%20is%20a%20long%20formula.%20Is%20it%20possible%20that%20it%20is%20too%20long%3F%20Does%20Sharepoint%20have%20a%20limit%20for%20formula%20length%3F%3C%2FP%3E%3CP%3EThanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1479076%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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!

2 Replies

@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

@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.