Nested IF's with blank cells.

Coen
Coen ✭✭✭✭
edited 09/19/23 in Formulas and Functions

Good afternoon Community!


I'm working on a formula that will Assign a "New" or "Old" Cost center based on a date field. I have this functioning properly using the following formula:

=IF([Transaction Date]@row < DATE(2023, 3, 31), "Old - Cost Center", "New - Cost Center")

Now, I am trying to add in a feature that will leave the cost center field blank if [Transaction Date] is blank. I've tried nesting If's and using ISBLANK without any luck.


tyty

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!