Again.. to new to get it.., I want to pickup a value based on a rule using the claculated value. UI want to pickup what user changed a dropdown value to "Complete". I started like this. But of course its not working 
I'm looking at it but.. anyone give me a hint please
equals(Task, "Complete"),userProfileLookup(Current User,"PreferredName")
hey @JHjalmarsson ,
u can try this formula:
if(Task == "Complete", userProfileLookup(Current User, "PreferredName"), "")
If the Task Dropdown is "Complete" then u will get the PreferredName from the current User... if it is something else then its empty. 🙂
hey @JHjalmarsson ,
yes, u have to put it there:
if(Task == "Complete", userProfileLookup(Current User, "PreferredName") + CurrentDate, "")
If u want to format the date u can use formatDate (german date example):
if(Task == "Complete", userProfileLookup(Current User, "PreferredName") + formatDate(CurrentDate, "dd.MM.yyyy"), "")
for US formats u can look here:
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.