Case Formula Not Working
I am trying to create an email subject line based on a selection of contract type and then combine those items into a string that can be used as an email notification subject line....getting errors ...
Forum Discussion
We have success!...Thanks for the help Mark
Correct formula and result
Case([Contract Type],
"GC Install", List("-",[Customer Name],[GC or 3rd Party Name],ToFormattedText([Date Submitted to Legal],"MMDDYYY"),ToFormattedText([Contract Amount],"comma_dot")),
"Direct to Customer Install", List("-",[Customer Name],ToFormattedText([Date Submitted to Legal],"MMDDYYY"),ToFormattedText([Contract Amount],"comma_dot")),
"Customer Service Contract", List("-",[Customer Name],ToFormattedText([Date Submitted to Legal],"MMDDYYY"),ToFormattedText([Contract Amount],"comma_dot")),
"Customer Indirect 3rd Party Service Agreement", List("-",[Customer Name],[GC or 3rd Party Name],ToFormattedText([Date Submitted to Legal],"MMDDYYY"),ToFormattedText([Contract Amount],"comma_dot")))
Customer-Hussmann-06-21-2017 12:00 AM-35,000
Correct formula and result
Case([Contract Type],
"GC Install", List("-",[Customer Name],[GC or 3rd Party Name],ToFormattedText([Date Submitted to Legal],"MMDDYYY"),ToFormattedText([Contract Amount],"comma_dot")),
"Direct to Customer Install", List("-",[Customer Name],ToFormattedText([Date Submitted to Legal],"MMDDYYY"),ToFormattedText([Contract Amount],"comma_dot")),
"Customer Service Contract", List("-",[Customer Name],ToFormattedText([Date Submitted to Legal],"MMDDYYY"),ToFormattedText([Contract Amount],"comma_dot")),
"Customer Indirect 3rd Party Service Agreement", List("-",[Customer Name],[GC or 3rd Party Name],ToFormattedText([Date Submitted to Legal],"MMDDYYY"),ToFormattedText([Contract Amount],"comma_dot")))
Customer-Hussmann-06-21-2017 12:00 AM-35,000