Forum Discussion
Tabitha1225
Apr 17, 2023Copper Contributor
Help determining what / how to pull and replace data using identifier
Not sure if I am using the right terminology so bare with me. I am trying to create a spreadsheet with one tab having a list of "planned budget" items which forecasts our team's projected spend for...
peiyezhu
Apr 18, 2023Bronze Contributor
application ID to the planned budget when we receive it and once that is entered,
??
Sorry,I am confused about the topic.
How about Microsoft form to collect info?
The two sheets Planned and Actual are same?
Why divide to two worksheets rather one sheet?
??
Sorry,I am confused about the topic.
How about Microsoft form to collect info?
The two sheets Planned and Actual are same?
Why divide to two worksheets rather one sheet?
Tabitha1225
Apr 18, 2023Copper Contributor
The planned spend and actual are different. On spreadsheet is what we "plan" or protect to spend on a particular donation. This also includes several other points of data we need. The other is what is "actual" based on the data received via application which we download weekly and upload on the sheet. I am trying to find a way to basically merge the two lists so when the "actual" is submitted it overrides what is on the "plan"