Forum Discussion

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, woul...

excel

Formulas and Functions

Office Scripts

HansVogelaar
Aug 15, 2022
busymamabee

=IF(TODAY()>C8,IF(OR(E8:G8=""),"Incomplete","Complete"),"")

HansVogelaar

MVP

Aug 13, 2022

busymamabee

Enter the following formula in D7:

=IF(OR(E7:G7=""),"Incomplete","")

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.

HansVogelaar
MVP
Aug 15, 2022
busymamabee

=IF(AND(TODAY()>C7,OR(E7:G7="")),"Incomplete","")
- busymamabee
  Copper Contributor
  Aug 15, 2022
  HansVogelaar
  
  It seems like this is freezing the result to "Complete" now regardless of the date or if the other cells have anything populated or not.
  
  The formula I have written is:
  =IF(AND(TODAY()>C8,OR(E8:G8="")), "Incomplete","Complete")
  - HansVogelaar
    MVP
    Aug 15, 2022
    busymamabee
    
    =IF(TODAY()>C8,IF(OR(E8:G8=""),"Incomplete","Complete"),"")