From Responses Updating Another Table

Hey Everyone:

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?

Description / Planned Activity/ Update / GTM Date?

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.