Skip to main content

Formula for rollup field and a comma

  • June 19, 2021
  • 2 replies
  • 32 views

Forum|alt.badge.img+2

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.

2 replies

Forum|alt.badge.img+7
  • Participating Frequently
  • June 20, 2021

hi,
try to set a condition before, something like

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

Forum|alt.badge.img+2
  • Author
  • Known Participant
  • June 20, 2021

hi,
try to set a condition before, something like

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

Thank you for the solution!