AnsweredAssumed Answered

The Formula Must Be of Type Date Error with Ifelse formula

Question asked by Adam Ritchie on Nov 10, 2018
Latest reply on Nov 11, 2018 by Patrick McQueen

I am trying to return a specific date based on the team name field. If the team name is ABC, pull the date from a related opportunities field, othewise make the date equal to the close date plus a given lead time. Here is the formula I am currently working with but I keep getting an error that says "The formula must be of type date":

ifElse(equal($team_name_c,"ABC"),related($opportunities,"revenue_start_date_c"),addDays($date_closed,multiply($lead_time_c,7)))

Outcomes