If cells in a range are blank, return blank; otherwise show max date.
Hello, I am new to Smartsheet and need assistance on this formula. Columns labeled 15 will have different dates input into them depending on when the appropriate file is collected. I want the Completed Date column to do two things:
 If any cells in the row for columns 15 are blank, I need the Completed Date column to remain empty.
 If all dates are filled in columns 15, I need the Completed Date column to show the max date.
Not sure if this can be done, I have been playing around with formulas using ISBLANK and OR so far, but I can’t get it quite right. Thank you.
Best Answer

Hi, Jasmine
Try, the following formula in your column named Completed Date.
=IF(COUNTIF([1]@row:[5]@row,@cell<>"")=5,MAX([1]@row:[5]@row),"")
Since Completed Date is to be blank unless all 5 dates are filledin, you can use COUNTIF() to evaluate the range.
Answers

Hi, Jasmine
Try, the following formula in your column named Completed Date.
=IF(COUNTIF([1]@row:[5]@row,@cell<>"")=5,MAX([1]@row:[5]@row),"")
Since Completed Date is to be blank unless all 5 dates are filledin, you can use COUNTIF() to evaluate the range.

This worked, thank you so much!
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 127 Brandfolder
 154 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!