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?
User | Count |
---|---|
34 | |
11 | |
3 | |
2 | |
2 |