if formula to change values to zero

[ManuelRodrigues]

Hi Team,

I am looking to convert the rows that are highlighted to zero could i pls ask if you have any suggestions?

Thanks in adv!

[ChrisTX]

You didn't provide enough information.  What should the logic be based on?  Row number, Name, Value?

By "convert.... to zero", I'm guessing you mean the Value field?

If you were doing it manually, what logic would you use to not update the Value for the first 3 rows?

[ManuelRodrigues]

@ChrisTX  the logic would be based on the name column I have tried if logics with AND or IN and none of these work.

[atcodedog05]

Hi @ManuelRodrigues 

Are you saying only specific names values should be 0.

Can you provide some sample input and expected output It will help us get a better understanding of the usecase.

We will be happy to help : )

[ManuelRodrigues]

here is the sample

[ChrisTX]

I don't think anyone can help you, because you have not provided the basic criteria that should be used to identify the rows that should be updated.

If you were doing it manually, what logic would you use?

[atcodedog05 · Accepted solution]

Hi @ManuelRodrigues 

Here is how you can do it.

Workflow:

Hope this helps : )

[atcodedog05]

Happy to help : ) @ManuelRodrigues 
Cheers and have a nice day!