Announcements
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
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.
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)
Put one of the Departsments as the default in the formula:
If(SharePointForm1.Mode=FormMode.Edit,"-","Accounting")
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
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 283
Mohsin Ali 221
