Skip to main content
Solved

Formula to display most recent input based on multiple field

  • January 31, 2024
  • 2 replies
  • 56 views
T
Forum|alt.badge.img+3

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.

 

Best answer by Alexey_Gusev

Hi,

 

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

 

1 Attachments

2 replies

Alexey_Gusev
Forum|alt.badge.img+25
  • Alexey_Gusev
  • Brainy
  • Answer
  • January 31, 2024

Hi,

 

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

 

T
Forum|alt.badge.img+3
  • ta2530
  • Author
  • New Participant
  • February 1, 2024

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.

Terms & ConditionsAccessibility statement