I am trying to apply formula on two columns and create another column that would hold the result.
i used formula to achieve this. However, the formula applies it to all the rows. My formula was IF [Employee Name] = "Pavithra" and [Percentage] >0.1 then "More than 10%" else "Not achieved the threshold" endif
Please help
Solved! Go to Solution.
Here is a workflow for the task.
Workflow:
IF [Employee Name] = "Pavithra" and [Percentage] >0.1 THEN "More than 10%"
ELSEIF [Employee Name] = "Kishore" and [Percentage] >0.6 THEN "More than 60%"
// add more elseif for conditions
ELSE "Not achieved the threshold" ENDIF
Hope this helps 🙂
If this post helps you please mark it as solution. And give a like if you dont mind 😀👍
Hi, the criteria must be applied only on first 2 rows. if the first is not greater than 10% or if the second row is not greater than 60%, only then the "Ouput" must have not achieved the threshold. The 3rd and 4th row must be left null.
This really helped. I have an extended calculation to carry out. If i want to check if row 4 is a sum of row 1 and row 2 , how can i incorprate the same in the formula?
Employee Name | Percentage | new field |
Pavithra | 0.1254 | More than 10% |
Kishore | 1 | |
Tripthi | 23 | |
Jagdish | 24 | This is a sum of row 3 and row 2 |
So this is my requirement. It can either be comment or the cell colored as red or green based on the result.
Here is the workflow:
I have built over the previous if statement
[Row-1] is previous row [Row-2] 2 rows before current so on
Hope this helps🙂
In my previous comment, i meant can the cell be colored red or green based on the value? That is if the sum of row 2 and row 3 is equal to row 4 then the cell will be colored green, else would be coloured red