Last 4 digits formula | Help and How-To

tcfd135 · 2025-10-03T18:53:11.514000Z

I am an ESO user and am trying to create a widget that will show only the final 4 digits of an incident number. The beginning of the incident numbers are not always the same but the last 4 are what I need. In excel I use =right(A2,4). I then use this list in excel with an =if formula (=if(c3-c2=1,"","missing") to show me any incident numbers that were not reported. If there is a way to make this part of the widget also, it would make my job that much easier. Thank you.

MoreDiscussions

Last 4 digits formula | Help and How-To | Sisense Community