Hi, I have an assignment please refer the below sample and suggest a solution. Total FeeFee 1Fee 2Fee 30 or Null122313213113213221321NullNullNull21352112121Null21431 Condition to check: if [Total Fee] is blank or 0 then [Fee 1], [Fee 2], [Fee 3] should be populated and if [Total Fee] = some amount then all the remaining files can be left blank. Please suggest a solution for the same

Data Validation

Hi,

I have an assignment please refer the below sample and suggest a solution.

Total Fee	Fee 1	Fee 2	Fee 3
0 or Null	12231	32131	13213
221321	Null	Null	Null
213521	12121	Null	21431

Condition to check:

if [Total Fee] is blank or 0 then [Fee 1], [Fee 2], [Fee 3] should be populated and if [Total Fee] = some amount then all the remaining files can be left blank.

Please suggest a solution for the same

Datasets

Accepted answers

atcodedog05

Hi @vijaylnyadav

Something like this.

Workflow attached.

fee (1).yxmd

All comments

atcodedog05

Hi @vijaylnyadav

Here is a workflow for the task.

Output:

Workflow:

Using validation formula on all columns.

Hope this helps 🙂 Feel to ask if you have any questions

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

fee.yxmd

vijaylnyadav

Hi,

I want to save the value as error in another column and does not manipulate any of the values in present column.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703