Since migrating SharePoint sites from 2010 to Office 365 a weird issue has been thrown up.
Some fields which are use as a calculated value use the value of [Me] to get the current user. But when using Office 365 on SharePoint this is prepended by i:0#.f|membership|
To fix this, replace [Me] and add this to the calculated query in the field:
=RIGHT(Me,LEN(Me)-18)
Some fields which are use as a calculated value use the value of [Me] to get the current user. But when using Office 365 on SharePoint this is prepended by i:0#.f|membership|
To fix this, replace [Me] and add this to the calculated query in the field:
=RIGHT(Me,LEN(Me)-18)