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?
@Rob Elliott 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.