How to filter on INPUT()

[McSwaggee]

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.

[Luis_DfG]

What about a condition in the Suggested values rule, inside the Auto compute section for the column that will contain the sprint ID column in the Tasks table?