How to prevent IF function from removing cell data when false

SuperDigital ✭✭✭
edited 01/11/23 in Formulas and Functions

My team is currently tracking customer services and monthly rate before and after talking with an agent, using a form that I created. I am trying to set up a formula that if we select that there are no changes made to the account it will copy over the data from the incoming fields to the outcoming. I am using this IF formula:

=IF([Was there a change to the service?]@row = "Service Not Changed", ([Outcoming MRC]@row=[Incoming MRC]@row).

This formula works if there was no changes made, but if changes were made the function is erasing the data that was inputted through the form. Is there anyway to prevent the data from being erased? Is there maybe a better way to do what i'm trying to do? Any help would be greatly appreciated.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!