CODEWITHSUNDEEP
rimportr-googlesheets
WageSlave
WageSlave

Reputation: 1

How to fix failure to import formula result from a Google sheet into R

I'm trying to import data from a Google spreadsheet, but I can't import the value in this case when the result is derived from a formula. I've had success with other formulas, but there is something different about this one which is causing me problems.

In the code below, I've linked to an example spreadsheet. The first column uses a formula to return the result. The second column simply lists the same value.

After importing to R, the first value comes in as #REF! while the next value imports just fine. I've experimented with various data type specifications, but nothing has worked for me.

Thanks in advance for any help that you can provide.

library(googlesheets)

troubleshoot_import <- gs_url("https://docs.google.com/spreadsheets/d/1OUAnCA1jD1aq5wSoaCyuDKcMP74bmuy8DrVTjxhw6zs/edit#gid=0")

import_test <-  gs_read(ss=troubleshoot_import, ws = "Sheet1", skip=0)

Upvotes: 0

Views: 55

Answers (0)

Related Questions