Help

Formula for rollup field and a comma

Topic Labels: Formulas
993 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Mark_Comish
6 - Interface Innovator
6 - Interface Innovator

I need help with an IF formula. I have a roll-up field that sometimes has 1 number and sometimes 2 or more numbers separated by commas. I have a formula that removes everything after the first comma but if there are no commas the formula field is empty.
image

2 Replies 2
Ilan_Ben_Yaakov
6 - Interface Innovator
6 - Interface Innovator

hi,
try to set a condition before, something like

if (find(",",{field})=0,[MID...])

Thank you for the solution!