Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

Ref to a changing source

Hi, I'm working on an app for a construction company that employees will use. One of the questions asked in the app is what project this report is being filed for, the options for this are drawn from a spreadsheet that has all of the currently active projects on it. However this sheet deletes the names of projects when they are completed so any projects completed under that project get assigned with whatever number row it was in the sheet. Any way to work around this?

0 1 78
1 REPLY 1
Top Labels in this Space