Nick055
Nick055
-
Re: avg(Collect) not working
Hi Robert, I've been playing around with this & I suspect the Job # Lot Size's are using a different character than ' which is causing it to not be considered equal. I've encountered something li…1 · -
Re: SUMIF formula based on multiple contact columns
Hi Kate! I have an idea on this, hopefully it helps! In this "ColumnE" is referring to your helper column with the combined names & "ColumnA" is the one you want the sum of. =…1 · -
Re: Formula to identify the task name of next child task due
Try this & let me know if it fixes it! =INDEX([Task Name]:[Task Name], MATCH(MIN(COLLECT([Target End Date]:[Target End Date], [Target End Date]:[Target End Date], ISDATE(@cell), Status:Status, &l…1 · -
Re: Formula to check a parent checkbox when any child is complete & formula to complete a parent status
Hi Anthony, I am not sure if this is exactly what you are asking for but it might help. I do have two solutions for the "Stage Status" formula ----------------------- This solution is if yo…1 ·
