Because I haven't found a better place to say this, and because a great deal of this has involved Formulas etc., I wanted to express my gratitude to this community. I'm not usually a community guy mostly because I feel intimidated. But what I'm trying to put together for my company has been important enough I was motivated. I have been helped so graciously I start getting excited about coming back here to be involved.
Having said that... lol
I am working on a tracking system where a form submission sets off a series of workflows which, when triggered will copy a row from one sheet to another. In fact, the form submission sets in motion two of these.
The Challenge:
I'm using a Formula, which I actually got here, to raise a flag anytime the date is less than (older) than today.
It works wonderfully.
My hope was to pre-populate the necessary Flag Columns for several (what I thought might be) empty rows so when the new rows were pasted, the formula would already be in place.
Of course that's not how it works, and not what happened. Each of the rows with the formula in a cell are seen as filled rows and the new rows just get placed at the end and without the formula.
In this image below there is 1) the row with the Formula triggered, 2) an example of a column pre-populated in an otherwise "empty" row and then where the newly pasted row ends up in this scenario.
Not sure if what I'm trying to do is even possible.
Thoughts?