Help

Formula to display most recent input based on multiple field

Solved
Jump to Solution
178 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.