You’re offline. This is a read only version of the page.
122
I have a Excel table named, "Results".
In the table there is column named "Completed", with values "true" or "false".
I need to query that table to find out if Record #2 is true or false.
If true, I want to mark a checkbox with a check.
Shouldn't this work?:
Default = LookUp(Results,ID="2",Completed)
I can use that function to get the text to read "true" but I need a checkbox checked.
Nothing seems to work.
Change the default property to:
If(LookUp(Results,ID="2",Completed)="true",true,false)
See if doing this would help.
Regards,
Michael
Share
Report
All responses (
Answers (
