ANY(SELECT

[jonbowles84]

HI Guys, is there anything wrong with this expression?

ANY(SELECT(Projects[Contact Name], ([Project] = [Project Number])))

I'm trying to add a default value to a [name] column, in a timesheet app where [project] = Projects[project number]

[TeeSee1 · Accepted solution]

@jonbowles84 

you probably need [_THISROW] in front of ether [Project] or [Project Number]

Assuming this expression belongs to a table other than Project and [project] is the column in this other table, then it should be in front of [Project]. (=> [_THISROW].[Project] = [Project Number])

See troubleshooting of this article

[jonbowles84]

Perfect, thankyou!