New answers tagged

2

Try this: =IF(LEN([YourColumn])=9,IF(MID([YourColumn],6,1)=".",IF(ISNUMBER(VALUE((MID([YourColumn],1,5)))),ISNUMBER(VALUE((MID([YourColumn],7,3)))),FALSE),FALSE),FALSE) First it validates if it's a 9 character string or not, then checks if the 6th character is a dot (.), then it validates the first 5 and last 3 characters. Of course, it might be ...


0

It is possible to show job titles below each name in a multi-level Google Org Chart while keeping the hierarchy intact. Using the documentation on https://developers.google.com/chart/interactive/docs/gallery/orgchart, I was able to modify the following line provided by Mohamed El-Qassas MVP... data.addRow([items[i]['Title'] +'</br>' + items[i]['...


2

You just need to concatenate items[i]['Title'] with items[i]['Job_Title'] at below line. data.addRow([items[i]['Title'] +'</br>' + items[i]['Job_Title'],items[i]['Manager']['Title'],'']); The Output based on my test Unfortunately, the above change would work only for one level org chart, because the Goole Org-Chart code mainly depends on the Name ...


Top 50 recent answers are included