ContributionsMost RecentMost LikesSolutionsRelationship fields: StatusI have a project parent table and report child table. In the report table, my team creates monthly reports that include an overall status field. I'd like to be able to display that overall status field in my project record with some logic that says, pull the overall status from the most recently added monthly report record. any ideas?Re: Calculating duration between two date fields but working days only?you're the best Mark. thank youRe: Calculating duration between two date fields but working days only?maybe i just need to change the workdate to regular date. I'll give that a try. thank you MarkRe: Calculating duration between two date fields but working days only?Thanks Mark but I got the "Expected duration but found number" messageRe: Calculating duration between two date fields but working days only?WeekDaySub([Start],[Projected Finish]) Re: Calculating duration between two date fields but working days only?I've tried this but I get "Expecting date but found workdate". Any ideas?Re: Adding records (tasks) more effectivelyNow I feel silly :). I have an embedded report and they can use the grid edit to create multiple records. They can even copy and past from a spreadsheet. So...ignore this one but thanks anyway.Adding records (tasks) more effectivelyCurious if anyone can think of a more effective way to add multiple child records other than one by one and import. My users are adopting the tool but they love grid edit to update multiple records at once. A method to allow them to add multiple records, without the potential mistakes that can be made by importing (something I'd like to avoid), would be great. Perhaps this is a question for the developers but wondering if anyone has discovered something I haven't.Re: Compare 2 dates and output a specific word in a third fieldthank you so much, Mark!Re: Compare 2 dates and output a specific word in a third fieldWow, that worked. I can't thank you enough. Any chance I could add a color to the field? green for on time and red for late?