formula help
3 Topics
Formula help needed
Hi all. I need help with a simple formula, I've been trying for days, but I'm unable to find a solution... In a list, I have: A column called [Power] with choices from 1 to 4. A column called [Impact] with choices from 1 to 4. A column called [Total_Score] with formula= [Power]*[Impact]. My quest: A column called [Management_Style], a calculated column, where I would like to make a matrix (powerXImpact) Matrix: If power =3 or 4, and impact = 3 or 4; then "Manage Closely" If power= 3 or 4, and impact =1 or 2; then "Keep Satisfied" if power = 1 or 2, and Impact = 3 or 4; then "Keep Informed" If power= 1 or 2, and impact= 1 or 2; then "Monitor (Minimum Effort)" I tried many types if multiple IFs, ANDs, ORs, but I could not find the right formula. Any help is really appreciated. Thank you all!Solved1.1KViews0likes1CommentUsing calculated formulas for time in lists
I have [Check-In] and [Check-Out] time and date column entries I then have a [Total Time] calculated column which uses this formula =TEXT([Check-In]-[Check-Out],"h:mm") I can get the total time, however I need to be able to set an IF for if the [Lunch Break] column yes/no is "Yes" it will deduct -0.5 or 30mins in the [Total Time] I have attempted a few methods however I keep getting syntax or incorrect values.Solved7.9KViews0likes2Comments
Help with Completed Date Formatting in Calculated Column
In search of a formula that will calculate the working hours Monday-Friday , 8 hour days. Excluding weekends. The reason is, I am looking for real duration of project during working hours. Currently I have the below as the Calculated formula, but need to get the hours correct. =TEXT([Completed Date]-Created,"h:mm") Thank you!Solved1.4KViews0likes2Comments
