Tyson Biegler
Reputation: 100
Google sheets function if cell is blank add text to another cell
I have a dropshipping spreadsheet that I'm working on and I have a cell in one column that contains a tracking number, and another cell that I put "Yes" or "No" for if it has been shipped.
| Tracking# | Shipped |
|---|---|
| 13213654 | Yes |
| No |
I want my sheet to check if there is a tracking number and then add yes or no to the adjacent cell in the shipped column.
Can anyone help me with a script? I'm new to coding.
Upvotes: 1
Views: 2444
Answers (1)
Related Questions
- If cell is empty, make reference to another cell of other column in the same row
- If cell contains a text then add text automatically to another column cell
- If cell is blank, show value in the another cell
- Google Sheets - Insert text automatically when cell is not empty
- Put formula in cell if another cell is not empty
- Combine Text and Formula using Concatenate and if cell is not blank Function
- Google Sheets -fill a cell with contents of a different cell when not blank
- Excel If cell is empty want to move data from another cell
- Add text if blank otherwise leave value
- EXCEL VBA help - function to insert blank cell