I’m having trouble figuring out how to do a simple thing. Our non-profit rents out our facilities. Applicants…

I'm having trouble figuring out how to do a simple thing. Our non-profit rents out our facilities. Applicants complete google form which dumps event data into google sheet. I'm trying to merge the responses from the sheet into a google doc contract but can't figure out how to merge just one row. The sheet contains info from all applicants (name, event date requested, etc.) and I want to create a contract with the latest applicant's data merged into the contract. Set up conditional formatting? How do I do that to just pull in the latest applicant's row?



Related Posts Plugin for WordPress, Blogger...