Hi, I need help with a formula. I need to identify any cells that do NOT have a whole number. Any suggestions?
Solved! Go to Solution.
Have I missed something or could we not use a regex_match function here?
IF REGEX_Match(ToString([Numbers]), '\d+')
THEN 'Whole'
ELSE 'Not Whole'
ENDIF
If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.
Regards,
Jonathan
Hi @reginawhelan ,
I think @atcodedog05's solution was the right idea - I would just write the calculation a little different - like so:
if [Field1]/floor([Field1])=1
then 'Whole'
else 'Not whole'
endif
But it's a subtle difference only, think it's about preference. Would love to see why that (or the above) solution does not work in your case, so let us know maybe with how it fails if it still doesn't work.
Regards,
Tom
Thank you all for your help!
Did it solve @reginawhelan ?