I have a table “Demo” that has a column “Status” which is a lookup into another Table “Status.Status” . I want to set a default value for Demo.Status to “Ordered” which is one of the values in the lookup table.
How do I achieve this in the default formula?