Forum Discussion

Copper Contributor

Mar 08, 2020

Solved

A complicated IF

I have three columns Confidence levels (High, Medium, Low) Training Date Reassessment Date I would like this column to automatically show the date for the following High: add 90 days to trainin...

Formulas and Functions

Mar 08, 2020

As variant

=B1+IFNA(INDEX({30,60,90},MATCH(A1,{"Low","Medium","High"},0)),0)

Diamond Contributor

Mar 08, 2020

As variant

=B1+IFNA(INDEX({30,60,90},MATCH(A1,{"Low","Medium","High"},0)),0)

sgtbrowne
Copper Contributor
Mar 08, 2020
Or is there a way to make it so every time I make a new row, the formula is there automatically?
- SergeiBaklan
  Diamond Contributor
  Mar 08, 2020
  sgtbrowne
  
  If use Excel Tables formulas will be repeated automatically for every new row of the table.
  - sgtbrowne
    Copper Contributor
    Mar 08, 2020
    Is there a way for me to adjust the if so when the confidence and training date hasn't been inputted, the cell stays blank? Right now, it's putting in 1/0/1900.
sgtbrowne
Copper Contributor
Mar 08, 2020
SergeiBaklan Can I include this in a data validation? If so how?
- SergeiBaklan
  Diamond Contributor
  Mar 08, 2020
  sgtbrowne
  
  I didn't catch about data validation, what is the purpose. Is that for Reassessment Date which entered manually?
  - sgtbrowne
    Copper Contributor
    Mar 08, 2020
    I am using some data validation that allows certain dropdowns to already be present in each row of certain columns. I would like to be able to do the same thing with the formula. Right now, I would have to copy and paste the entry in each time and I would like to make this excel sheet as automated as possible.

Resources