I have ONE transaction that does not have the Category drop-down to choose the Category. This is with the Tiller Foundation Template in Google Sheets. How can I restore? TU
1 Like
Sorry for bandwidth - I restored a prevous version of Sheets, and problem vanished. All good now.
2 Likes
Restoring previous version of Sheets didn’t work this time - what causes this and how to fix?
Read this article
Troubleshooting the Category dropdown in the Transactions sheet | Tiller Help Center ..
1 Like
Hello @wa9als , not sure what would cause this, but if you copy and paste the drop down from another cell that has the drop down it will put the drop down back.
I have a spreadsheet I use to track my work and it has a couple of drop downs that let me specify what task I am doing. I use Google Apps Script code to insert a row at row 2 so that it will inherit the drop down from the current row 2. My code doesn’t insert the drop down, just the inheriting of the formatting.
I suspect that when the transactions were inserted, for some reason the way they were inserted didn’t insert them next to the drop down that the drop down would be inherited (this is a total guess).
The easy temporary fix is literally to copy paste the drop down from a cell that has the drop down to the missing transaction. I feel like, but can’t remember when, this has happened to me before and doing that copy/paste fixed it going forward.
-Alice
Tiller Evangelist
Thanks. I did that and it worked.
1 Like