Data Validation

[vijaylnyadav]

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

[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 😀👍

[vijaylnyadav]

Hi,

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

[atcodedog05]

Hi @vijaylnyadav 

Are you looking for something like this

Workflow:

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 😀👍

[vijaylnyadav]

i want an another column as a Error/Validated if the condition full-fills then its value is "validated "and if not then its value is "error" 

[atcodedog05 · Accepted solution]

Hi @vijaylnyadav 

Something like this.

Workflow attached.

[vijaylnyadav]

Thanks for your help

[atcodedog05]

Happy to help 🙂 @vijaylnyadav 

Cheers and Happy Analyzing 😀

Feel free to reach out if you face any issues 🙂