referencing a formula within another

[wonka1234]

Hi,

I am trying to adjust my formula for this:

and when I transpose I get this:

But OE Conclusion should have "Field Requires a value" correspond to it in the Exception column.

My formulas

after i do this i transpose to the result you see above.

What am I doing wrong?

[binu_acs]

@wonka1234 Can you replace the OR in the formula with AND and try again ?

[martinding]

Hi @wonka1234 ,

Would you be able to provide some dummy data? 

It is a bit hard to diagnose the formula without understanding what's going on at the data level.

Cheers 

[wonka1234]

Sample data

Pass or Fail

Test 1

Test 2

Test 3

Test 4

Test 5

Test 6

Comment

Comment1

Test 7

Test 8

Test 9

Test 10

Test 11

Test 12

Test 13

Test 14

Test 15

FAIL

Approval

Completed Date

Requires a Value

OE Conclusion

OE Conclusion

[wonka1234]

@martinding @binu_acs  There could be multiple values for a "test" in a row/record...  And some tests need a certain "comment" .

[martinding]

Hi @wonka1234 

Thanks for the sample data.

I noticed that in your original question, the expected output contained multiple Completed Date values in the Exception column, in the sample data, there's only a single column (and single row) "Comment" that contains the "Completed Date".

May I ask how the transpose was done? Was it like this?

Because in the Formula tool, what we are updating is the Comment 1 field, so it is not actually changing the values corresponding to the Tests. If we want to update OE Conclusion corresponding to Test 8 and 9, we'd have to write something like this:

[wonka1234]

@martinding  adding some extra screenshots to add clarity/ Formulas Comment 1 and Comment come after thiese

does this help?