Help

The Community will be undergoing maintenance from Friday February 21 - Friday, February 28 and will be "read only" during this time. To learn more, check out our Announcements blog post.

Alternative to Index Match (Match)

Topic Labels: Formulas
Solved
Jump to Solution
446 4
cancel
Showing results for 
Search instead for 
Did you mean: 
elmo
4 - Data Explorer
4 - Data Explorer

Hi there, I'm trying to bring a value from a previous row into another row, matching on two conditions.

For context, I am ultimately trying to compare the difference in revenue between two rows, submitted by the same company, in adjacent quarters.

Does anybody know how this could be done? Thank you!

1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

And so you're looking for something like this, but done automatically, is that right?

Screenshot 2025-01-22 at 10.34.20 AM.png

If so, you could try using an automation to find the previous quarter for you.  How that's done is going to depend on your data setup though, and with reference to the screenshot above I would create a formula field that would output the name of the previous quarter, and then the automation would consist of:

1. Find record action to look for the previous quarter's record
2. Update record action to link the triggering record to the previous quarter's record

See Solution in Thread

4 Replies 4
TheTimeSavingCo
18 - Pluto
18 - Pluto

And so you're looking for something like this, but done automatically, is that right?

Screenshot 2025-01-22 at 10.34.20 AM.png

If so, you could try using an automation to find the previous quarter for you.  How that's done is going to depend on your data setup though, and with reference to the screenshot above I would create a formula field that would output the name of the previous quarter, and then the automation would consist of:

1. Find record action to look for the previous quarter's record
2. Update record action to link the triggering record to the previous quarter's record

elmo
4 - Data Explorer
4 - Data Explorer

Hi Adam, thank you for this! I've had a go at creating this automation and am struggling - what steps do I need to take? 

Thanks again 🙂

I've updated the base with the automation!  The 'Previous quarter' field outputs the name of the previous quarter and pastes it into the linked field, which links it up appropriately

Screenshot 2025-01-22 at 6.40.38 PM.png

Screenshot 2025-01-22 at 6.40.30 PM.png

elmo
4 - Data Explorer
4 - Data Explorer

Thank you so much! I really appreciate it 🙂 exactly what I was looking for