Forum Discussion

MathewCrist's avatar
MathewCrist
Qrew Member
4 years ago

Change a status when a date is reached

HI, I'm looking for some advice on how to update a field when a date is reached. More specifically, we have a Campaigns table that includes a field for Campaign Status and Campaign End Date. ...
Formulas and functions
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago

I would keep it simple and just use a formula. 


I would have a status update field which can be updated manually and then a formula field, called [Status]

IF(Today() > [Campaign End Date], "Completed", [Status Update])

 



------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
MathewCrist's avatar
MathewCrist
Qrew Member
4 years ago
Hi Mark, I was able to get this to work. There would be a few benefits to making it a little more complex, and not creating a separate formula field, but I think this is good enough for now. 

Thanks!

Matt

------------------------------
Mathew Crist
------------------------------