Can someone help with this formula?

Community Discussions
,
1

=FINDROW(Data,"THISROW()[Date] = $[Row_storage][Date] AND THISROW()[Project] = $[Row_storage][Project]")

2

Hey @Will-7ebe,

I'd love to help you solve this issue. I'm assuming you have a table called Data and in the Data table you have a field/column for Date and Project, the Project column is formatted as Auto.

If my assumption is correct test using the following formula

=FINDROW(Data,"Data[Date]=$[Row_storage][Date] AND Data[Project] = $[Row_storage][Project]")

If you have your project column formatted as a RowLink let me know and I can provide an updated formula.

I hope my response is helpful!

Best Regards,

Nancy

1 Like