I am having an issue that I am sure is solve-able but I am stuck.
I have one table that houses all my company roadmap features. I then have an additional table that has a form for my team to go in and fillout weekly updates. The issue is that not every column updates each week.
Right now I have the Roadmap Items Table rolling up the max date and then using a formula on the other table to use that date to only pull in the most recent update for each column. That all works fine.
Where it falls apart is when a user submits the form but leaves one of the section unfilled because it doesn’t need to be updated from the last time. Is there a way to set it so I get a super set of the most recent update for each of my columns across multiple entries?