Aug 13 2022 01:59 PM
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
Aug 13 2022 02:48 PM
Aug 15 2022 05:48 AM
Aug 15 2022 06:05 AM
Aug 15 2022 06:14 AM
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")
Aug 15 2022 06:29 AM
SolutionAug 15 2022 06:31 AM
Aug 15 2022 06:29 AM
Solution
=IF(TODAY()>C8,IF(OR(E8:G8=""),"Incomplete","Complete"),"")