Skip to main content

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.

 

Hi,

 

IF(Q4,Q4,

IF(Q3,Q3,

IF(Q2,Q2,Q1)

) )

 

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.

Reply


Terms & Conditions