You need to sign in to do that
Don't have an account?
Glenn Nyhan 91
Will This Formula Even Work?
I have an end user who is asking me to create a formula to do the following and I'm not even sure this is possible, so I'm asking for some input from the community if this formula can even be created
The formula she is requesting is this:
If Ground Break Photos Upload Date >/= -14 days from Ground Break Date then Ground Break Report Due = Ground Break Date -7 days.
I've tried using the >= - 14 but I get an error message. I think it because of the Ground Break Photos Upload Date is a Date/Time field. So I'm not sure how to create a formula to handle that.
Any help is greatly appreciated.
Thanks,
Glenn
The formula she is requesting is this:
If Ground Break Photos Upload Date >/= -14 days from Ground Break Date then Ground Break Report Due = Ground Break Date -7 days.
I've tried using the >= - 14 but I get an error message. I think it because of the Ground Break Photos Upload Date is a Date/Time field. So I'm not sure how to create a formula to handle that.
Any help is greatly appreciated.
Thanks,
Glenn
1. Create a formula field and add the below condition.
IF((Ground Break Photos Upload Date >= Ground Break Date -14), Ground Break Date -7, null)
Thanks,
SEKAR RAJ
All Answers
1. Create a formula field and add the below condition.
IF((Ground Break Photos Upload Date >= Ground Break Date -14), Ground Break Date -7, null)
Thanks,
SEKAR RAJ