Hello my friends,
Let's see how to work with Conditional Formula like IF with Calculated Columns.
Demo: Create new List for this named: Products
Created following columns:
How calculated columns looks:
=ROUND(([UnitsInStock]*[ProductCost]),2)
=IF(([UnitsInStock]<[threshold]),"Yes","No")
Create a View needToOrder:
Do sorting for this View:
Click Ok to Save this new view for needToOrder and display this to HomePage.
For display it to homepage do following changes on home page add an app part for it and edit the webpart and the choose your view that you want to show in my case that is needToOrder.
My HomePage:
See values in different views, add some values and see how your list look like:
needToOrder View:
I hope you understand how to use Conditional formula (IF) with your calculated column for getting required result.