ALthough new is set to show department it is showing dash

[yougan]

I want to see as dash when editing the form and during other form modes such as new and view i should see department name

Although I applied logic correctly, new and view form showing as dash only. Please see refer attached screenshots

[eka24]

Can you show the logic or the formula you applied that is not working?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[yougan]

Hi Eka,

Thank you for the response. I have attached in my first thread same in screenshot called C1. Below is the logic I used.

If(SharePointForm1.Mode=FormMode.Edit,"-",ThisItem.Department)

[eka24 · Accepted solution]

Put one of the Departsments as the default in the formula:

If(SharePointForm1.Mode=FormMode.Edit,"-","Accounting")

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[yougan]

Hi Eka,

This is working but why it is not working previous one. It supposed to work right? 

instead of column value and I would like to declare column title itself saying ThisITem.Department

[eka24]

The earlier formula did not work because the default of the dropdown picks a text at a time. When you use ThisItem, it is not clear which of the items in the list should be selected as the default.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.