Jun 19, 2021 06:17 AM
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.
Jun 20, 2021 03:46 AM
hi,
try to set a condition before, something like
if (find(",",{field})=0,[MID...])
Jun 20, 2021 06:01 AM
Thank you for the solution!