cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dpimart
Frequent Visitor

Use formula for blank data in get excel rows

I have 2 separate excel workbooks, each with 1 table. 

Sheet1 table1 copy/pastes to Sheet2 table2 data.  

dpimart_0-1668392748568.png

I have monthly columns in each table and the data from each in ST1 gets copied over into the matching rows and columns of ST2. 

dpimart_1-1668392946713.png

However, if there are still months remaining in the year, then there will not be any data in ST1 to be copied over.  In that case, I need those blank month columns of ST2 to be a calculation which would be ((Plan - YTD Actuals) / # of remaining months).  

How do I add this in??

1 ACCEPTED SOLUTION

Accepted Solutions
SudeepGhatakNZ
Resident Rockstar
Resident Rockstar

Assuming they are both date columns, you could use the dateDifference function. It returns a Time span.

 

 

If my suggestion helped you, please give it a Thumbs up and mark it as a Solution so that it can benefit others in the community.

View solution in original post

1 REPLY 1
SudeepGhatakNZ
Resident Rockstar
Resident Rockstar

Assuming they are both date columns, you could use the dateDifference function. It returns a Time span.

 

 

If my suggestion helped you, please give it a Thumbs up and mark it as a Solution so that it can benefit others in the community.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,589)