Add formula to a row only based on the value

I have modified the formula

Output 1:

Output 2:

Please check and let me know.

We can use a table tool to color it. Color is determined in the multi-row formula tool

Output:

Workflow:

Render tool is required to output to excel with formatting

Hope this helps🙂

data (2).yxmd

You can use ToNumber() function like ToNumber([Percentage]) to convert string to number.

IF  [Employee Name] = "Pavithra" and ToNumber([Percentage]) >0.1 THEN "More than 10%" 
ELSEIF  [Employee Name] = "Kishore" and ToNumber([Percentage]) >0.6 THEN "More than 60%" 
// add more elseif for conditions
ELSE  "Not achieved the threshold" ENDIF

Hope this helps 🙂

Emil_Kos

IF [Employee Name] = "Pavithra" and ToNumber([Percentage]) >0.1 THEN "More than 10%"
ELSEIF [Employee Name] = "Kishore" and ToNumber([Percentage]) >0.6 THEN "More than 60%"
// add more elseif for conditions
ELSE "Not achieved the threshold" ENDIF

@atcodedog05 this time you are slightly faster then me 🙂

All comments

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.

I have modified the formula

Output 1:

Output 2:

Please check and let me know.

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?

Since the calculation is at row level we would need a Multi-row formula for it.

Can you give the requirement and expected output so that i can help you out🙂

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