How to return specific text in a cell if another cell is blank

NMM321

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?

Kerry St. Thomas

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/A

Good luck!

Kerry St. Thomas

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/A

Good luck!

NMM321

This worked great! Thank you!