Add a new row to a sheet based on data in another sheet

Options

Hi Community,

I'm trying to figure out if I can automatically add a row with data to a sheet (say Sheet B) when a value in Sheet A changes. The concept is if an escalation/issue arises, automatically create an entry in the issues/escalation log (sheet). But I don't want to simply copy the row - I want to create a new entry with the column applicable in Sheet B (Escalation/Issues). Referencing the image below, when the highlighted cell changes to 'In Progress' I want to create a row in Sheet B (Issues). The only data I need to fill in I think would be the name which in this case would be Parent 1 and maybe today's date. The row in Sheet B will be updated manually with pertinent information but I want to have it created automatically. Any ideas how to accomplish this? Thanks!


Answers