Can anyone tell me how I can put the following formula into an
infopath field? It's the only one I can't figure out because I can't
get the THEN bit to provide any options other than text formatting
=IF(Score<15,"Minor",IF(Score<25,"Significant",IF
(Score<35,"Major","Huge")))
In the SPv2 list this formula returned one of three values based on
the number referenced in the column called Score. Infopath doesn't
like the formula and I can't figure out how to get the THEN bit of the
statement in. Adding a condition when column X contains or is equal to
Z only gives me the option to THEN format the text colour and style
Can someone help?
Do you know someone who can help? Share a link to this thread on twitter, or facebook.