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")