AnsweredAssumed Answered

Looking to change a field value, based on a date field

Question asked by burghfan on Nov 3, 2017
Latest reply on Nov 5, 2017 by burghfan

Is there a way to use a conditional formula to change the value in one field based on the date from another field?

 

Example we have a Project TO (Layout) with a "Bid Date" field and another field based on a Value List - "Project Type" with four possible selections; "Bidding", "Pending", :"Awarded", "Dead".

 

Is there a way to switch "Bidding" to "Pending" if the "Current Date" is after the "Bid Date"

 

I am thinking of something along the lines of;

 

If ("Bid Date" < "Current Date") & ("Project Type" = "Bidding") then ("Project Type" = "Pending")

Outcomes