How to filter on INPUT()

Hi guys,

So I'm making a simple project management app.

Right now I'm using INPUT("Sprint ID", "") to select a Sprint ID for Task. This works however my issue is that it shows all Sprints. I only want to see Sprints which are not complete.

I want to do something like INPUT(SELECT(Sprints["Sprint ID"], [Status] = "To Start"), "") - but this doesn't work.

Any help would be really appreciated.

0 1 119
1 REPLY 1
Top Labels in this Space