I have a sharepoint site of huge data with different types of data filed.
In the column list we have three special columns where conditions need to be applied using formula for automatic calculation. Below conditions and column names are mentioned.
1> Planned Hours
Here Planned Hours is manual entry.
But we need Category column to be automated based on below condition
Below condition need to be implemented:
If Planned Hours is 2 to 4 hr then Category is Category 1
If Planned Hours is 4 to 8 hr then Category is Category 2
If Planned Hours is more than 8 hr then Category is Category 3
8 freelancers are bidding on average ₹781 for this job
I have 12 years of experience on SharePoint and great hands on experience with Power Apps. Your requirement can be quickly done using customized list forms or Power Apps. Let me know if I could be of any help to you.