How can I change the entry for one specific cell?

[hellyars]

I want to change the specific entry for just one field.  

In the example below I just want to change the value for History from 0 to something.  

Thanks

	History	Fiction	Kids
Books	0	13	34

[cmcclellan · Accepted solution]

A formula tool would do that, but how do you identify that row ?

From your example, I would say putting a formula on History that says:

If [F1] = "Books"

then 75

else [History]

endif

[Hakimipous · Accepted solution]

@hellyars

Here is an attached Workflow showing you how to do it.  It's the same solution as @cmcclellan , only I used a Filter Tool prior.

Let's us know if that helps x)

[Talliford]

this is helpful - how would i then still export all the rows of data I have with the new changed field? Wouldn't this output only show the filtered "books" row