Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Stack Internal
Knowledge at work
Bring the best of human thought and AI automation together at your work.
Explore Stack InternalI am struggling to get my column validation to be accepted.
This is the logic I am trying to replicate:
IF "Status" = "Successful" THEN "Date Completed" must be filled outpopulated AND "Date Completed" IS NOT in the future. Here is the formula I currently have:
=IF(Status="Successful", IF([Date Completed]<>"",TRUE,FALSE),TRUE) AND =[Date Completed]<=Today() I am struggling to get my column validation to be accepted.
This is the logic I am trying to replicate:
IF "Status" = "Successful" THEN "Date Completed" must be filled out AND "Date Completed" IS NOT in the future. Here is the formula I currently have:
=IF(Status="Successful", IF([Date Completed]<>"",TRUE,FALSE),TRUE) AND =[Date Completed]<=Today() I am struggling to get my column validation to be accepted.
This is the logic I am trying to replicate:
IF "Status" = "Successful" THEN "Date Completed" must be populated AND "Date Completed" IS NOT in the future. Here is the formula I currently have:
=IF(Status="Successful", IF([Date Completed]<>"",TRUE,FALSE),TRUE) AND =[Date Completed]<=Today() I am struggling to get my column validation to be accepted.
This is the logic I am trying to replicate:
IF "Status" = "Successful" THEN "Date Completed" must be filled out AND "Date Completed" IS NOT in the future.
IF "Status" = "Successful" THEN "Date Completed" must be filled out AND "Date Completed" IS NOT in the future. Here is the formula I currently have:
=IF(Status="Successful", IF([Date Completed]<>"",TRUE,FALSE),TRUE) AND =[Date Completed]<=Today() I am struggling to get my column validation to be accepted.
This is the logic I am trying to replicate:
IF "Status" = "Successful" THEN "Date Completed" must be filled out AND "Date Completed" IS NOT in the future.
Here is the formula I currently have:
=IF(Status="Successful", IF([Date Completed]<>"",TRUE,FALSE),TRUE) AND =[Date Completed]<=Today() I am struggling to get my column validation to be accepted.
This is the logic I am trying to replicate:
IF "Status" = "Successful" THEN "Date Completed" must be filled out AND "Date Completed" IS NOT in the future. Here is the formula I currently have:
=IF(Status="Successful", IF([Date Completed]<>"",TRUE,FALSE),TRUE) AND =[Date Completed]<=Today() I am struggling to get my column validation to be accepted.
This is the logic I am trying to replicate:
IF "Status" = "Successful" THEN "Date Completed" must be filled out AND "Date Completed" IS NOT in the future.
Here is the formula I currently have:
=IF(Status="Successful", IF([Date Completed]<>"",TRUE,FALSE),TRUE) AND =[Date Completed]<=Today()