Forum Discussion
SharePoint Calculated field based on the choice columns
Hello, I have a couple of fields on the SharePoint list with two choice fields as shown below- 1-Priority (1-High, 2-Medium, 3-Low) 2-Impact (1-High, 2-Medium, 3-Low) I would like to have a ca...
This looks like a job for a series of IF statements. Test out your formula in an Excel table first--once you get that debugged (SharePoint is a terrible platform for testing formulas, so I don't recommend starting there), change your field names to match SharePoint's field naming convention and your field should work.
Thanks, Matt, that's exactly what I did, excel formulas :). I used a simple formula with LEFT() function to address this issue.
Cheers.
