How to return specific text in a cell if another cell is blank
I have one column containing "Publication Date" and another containing "Next Review". How do I create a formula to populate the "Next Review" with a value of "N/A" if there is no value in the corresponding "Publication Date" column?
Best Answer
-
Your formula in NEXT REVIEW column could start with something along these lines:
=IF(ISBLANK([Publication Date]@row),"N/A", …(whatever you'd do if the Publication Date ISN'T blank) - if you make this a column formula, you'll lock the column.
If you need this to be an unlocked column that people can modify, you can also consider triggering an automation to populate with "N/A" on a periodic basis:
Trigger: when a date is reached> Custom> daily/weekly/whatever cadence
Condition: Where Publication Date is blank
Action: Change Cell Value in Next Review: N/AGood luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
Answers
-
Your formula in NEXT REVIEW column could start with something along these lines:
=IF(ISBLANK([Publication Date]@row),"N/A", …(whatever you'd do if the Publication Date ISN'T blank) - if you make this a column formula, you'll lock the column.
If you need this to be an unlocked column that people can modify, you can also consider triggering an automation to populate with "N/A" on a periodic basis:
Trigger: when a date is reached> Custom> daily/weekly/whatever cadence
Condition: Where Publication Date is blank
Action: Change Cell Value in Next Review: N/AGood luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
This worked great! Thank you!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!