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?
Google-sheets – Output data if value is less than today’s date
formulasgoogle sheetsgoogle-sheets-arrayformulagoogle-sheets-dates
Related Solutions
This is called concatenation of strings. There are three ways to do this in Google Sheets:
A2 ="You've picked" & A1
or
A2 =concatenate("You've picked", A1)
or
A2 =concat("You've picked", A1)
The difference between concatenate and concat is that the former accepts any number of strings, while the latter accepts only two. There isn't a reason to use concat, I mention it just for completeness.
Short answer
Yes, Google Sheets can.
Instructions
Optional. Select the range to apply the data validation
Right click on the selected range or click on Data > Validation...
Optional. Write/edit the range to apply the data validation
Click on Criteria and select Date
Set the rule options including a formula using the top left cell reference, i.e.
=A1
- Click on the Save button.
Related Topic
- Google-sheets – Copying data from one cell in another based on date
- Google-sheets – How to countif with dates before today’s date that auto updates
- Google Sheets – Query/Filter Function to Find Closest Date Less Than Order Date
- Google-sheets – In Google Sheets,how to get a value lower than a particular cell value in a row
- Google Sheets – Display List of Names if Date Matches Adjacent Cell
Best Answer