Forum Discussion

busymamabee's avatar
busymamabee
Copper Contributor
Aug 13, 2022
Solved

Updating Cell Value Automatically Based on Multiple Cell's Date

Hello!

I am attempting something that I'm not quite sure is possible. The goal would be for the cell in D7 to update automatically based on the the information in cells E7, F7, and G7. Ideally, would what happen is that if one of these cells is blank, the status will update to "Incomplete," where 

 

 

excel
Formulas and Functions
Office Scripts
    • busymamabee's avatar
      busymamabee
      Copper Contributor
      Aug 15, 2022
      Thank you! Is there a way to expand the formula so that it only kicks into gear after the date listed in C8?

      I tried =If(TODAY()>DATEVALUE(C8)(OR(E8:G8=""),"Incomplete","Complete") but it's coming back with an error.

Resources