Excel 2013 - Assign value to cell in Sheet2 based on a conditional in a cell in Sheet1

Question

I would like to assign values to cells in one sheet based on the values of cells in another sheet. I have followed this answer, but it appears to work only if both the reference cell and the target cell are in the same sheet.

For example, in Sheet1 Cell B1, I have the formula:

=IF(ISBLANK(A1),"",SetCellValue("C1",A1))

This results in Cell C1 being assigned whatever value is in A1. However, if I attempt to place the target cell in a different sheet:

=IF(ISBLANK(A1),"",SetCellValue("Sheet2!C1",A1))

the SetCellValue function returns a zero (meaning, the value was not written). I'm not particularly adept at VBA, so I'm not certain how to alter the code to get the desired results. Any thoughts? Thanks in advance!