Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I have a spreadsheet. I want to create a formula that checks the date of one cell and if the value is lower than today's date, it to output the word required into another cell. How would I do this?
=ARRAYFORMULA(IF(A1:A<>""; IF(A1:A < TODAY(); "required"; ); ))
=IF(A1 < TODAY(); "required"; )
Required, but never shown