Combining IF statements
Hi Smartsheet community,
I am currently trying to create a formula, that states if Updated Completed Date is blank then use the date in Original Completion Date column but if not blank then use the date in the Updated Completed Date column to return quarter and year (Q4 2020). I am creating this formula in the Estimated Completion Quarter column. Any help will be greatly appreciated. Thanks!
Help Article Resources
Check out the Formula Handbook template!