Forum Discussion

Tracey Lord's avatar
Tracey Lord
Copper Contributor
Aug 26, 2018

Excel Formulas

Can anybody please help me.  I have a spreadsheet that when a document is sent out a date is entered into a column, I also have another column where I have to manually type in yes when the date is entered (the document has gone).

 

My question is, can a formula be added to the yes column, so that it automatically is filled with yes when the date cell is entered?

excel

2 Replies

  • Philip West's avatar
    Philip West
    Steel Contributor
    Aug 26, 2018

    First, your 'Yes' column sounds a bit redundant? Filter the date column for blanks or not blanks and you have the same information?

     

    But to answer your question, this will do it. (assume your date is in A1, you will need to change that to match your table). =if(A1="","","Yes")

     

    Copy that down your yes column.