Wondering if someone could suggest the best way to accomplish the following.
I have a Projects table and a Tasks table. Projects table references the Tasks table and each project has multiple tasks. Both, the Projects and Tasks tables have a Status column to track the status. I would like the Project Status column to be automatically updated with “Completed” when all tasks have been marked “Completed”.
Would some sort of a lookup function work for this? Also, could this be done by placing an expression in the Formula field under Data -->Project Table → View Columns?