Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Formula to display most recent input based on multiple field

Solved
Jump to Solution
818 2
cancel
Showing results for 
Search instead for 
Did you mean: 
ta2530
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi there - I am looking to create a column that will essentially lookup the field values of columns Q1 - Q4 and output the latest number.

We input quarterly projections and want to be able to identify the most recent number by looking at 1 field ("latest projections"). *Note - not all fields will have data from Q1 - Q4.

I tried using the IF function but that only seems to work with 2 different fields max. ( IF(Q2> " ", Q2, Q1) )

If I have data entered in Q1 field and then in Q3 enter in new data in the respective Q3 field, I want the "Latest projections" column to display that Q3 field since it its the most up to date #.

I hope this makes sense. I will attach a screenshot for reference where I manually updated the "Latest Projection" field.

 

1 Solution

Accepted Solutions
Alexey_Gusev
12 - Earth
12 - Earth

Hi,

 

IF(Q4,Q4,
  IF(Q3,Q3,
    IF(Q2,Q2,Q1)
) )

 

See Solution in Thread

2 Replies 2
Alexey_Gusev
12 - Earth
12 - Earth

Hi,

 

IF(Q4,Q4,
  IF(Q3,Q3,
    IF(Q2,Q2,Q1)
) )

 

Thank you!

This worked well I just needed to add an additional ) at the end.