Hello All,
Hoping someone can help.
I need to add a date from another field into a calculated field if a certain field contains a specific team.
I have an existing field with some complicated calculations to determine a 'Latest Briefing Date' based off a requested date field but one team wants this calculation to be ignored just for them.
When their team name is selected in one field they just want the 'Requested Broadcast Date' to auto populate into the 'Latest Briefing Date' Field.
Below is the current calculation we have in the 'Latest Briefing Date' Field.
Solved! Go to Solution.
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
Hello Donna,
without having the possibility to try it in detail, I think using your last formula as a kind of wrapper around your current calculation could be the solution:
As the IF formula works like this:
IF(condition, trueExpression, falseExpression)
You could replace condition by the check for the teamID, trueExpression by the Requested Broadcast Date and falseExpression by your calculation.
IF({DE:oracleTeamID}=<teamID>,{DE:oracleRequestedBroadcastDate},IF(DAYOFWEEK({DE:oracleRequestedBroadcastDate})=1,{DE:oracleBriefingWeeksPrior}="REQUESTED BROADCAST DATE CANNOT BE A SATURDAY OR SUNDAY", IF(DAYOFWEEK({DE:oracleRequestedBroadcastDate})=7,{DE:oracleBriefingWeeksPrior}="REQUESTED BROADCAST DATE CANNOT BE A SATURDAY OR SUNDAY", IF(DAYOFWEEK({DE:oracleRequestedBroadcastDate})<=4,ADDDAYS({DE:oracleRequestedBroadcastDate},-7*{DE:oracleBriefingWeeksPrior}),IF(DAYOFWEEK({DE:oracleRequestedBroadcastDate})=5,ADDDAYS({DE:oracleRequestedBroadcastDate},(-7*({DE:oracleBriefingWeeksPrior}-1))-3),IF(DAYOFWEEK({DE:oracleRequestedBroadcastDate})=6,ADDDAYS({DE:oracleRequestedBroadcastDate},(-7*({DE:oracleBriefingWeeksPrior}-1))-4),{DE:oracleRequestedBroadcastDate}))))))
Regards
Lars
Hello Donna,
without having the possibility to try it in detail, I think using your last formula as a kind of wrapper around your current calculation could be the solution:
As the IF formula works like this:
IF(condition, trueExpression, falseExpression)
You could replace condition by the check for the teamID, trueExpression by the Requested Broadcast Date and falseExpression by your calculation.
IF({DE:oracleTeamID}=<teamID>,{DE:oracleRequestedBroadcastDate},IF(DAYOFWEEK({DE:oracleRequestedBroadcastDate})=1,{DE:oracleBriefingWeeksPrior}="REQUESTED BROADCAST DATE CANNOT BE A SATURDAY OR SUNDAY", IF(DAYOFWEEK({DE:oracleRequestedBroadcastDate})=7,{DE:oracleBriefingWeeksPrior}="REQUESTED BROADCAST DATE CANNOT BE A SATURDAY OR SUNDAY", IF(DAYOFWEEK({DE:oracleRequestedBroadcastDate})<=4,ADDDAYS({DE:oracleRequestedBroadcastDate},-7*{DE:oracleBriefingWeeksPrior}),IF(DAYOFWEEK({DE:oracleRequestedBroadcastDate})=5,ADDDAYS({DE:oracleRequestedBroadcastDate},(-7*({DE:oracleBriefingWeeksPrior}-1))-3),IF(DAYOFWEEK({DE:oracleRequestedBroadcastDate})=6,ADDDAYS({DE:oracleRequestedBroadcastDate},(-7*({DE:oracleBriefingWeeksPrior}-1))-4),{DE:oracleRequestedBroadcastDate}))))))
Regards
Lars
Thank you Lars,
This helped us figure out how to fix the formula!
We went with this in the end, which works and is pretty much what you suggested.
Views
Replies
Total Likes