problems with a custom field/formula with multiple IF's
Dear all,
we currently have the following data that we wan to work with:
1) a table that shows a few columns with different status information and dates 2) we would like to add custom columns showing a result of a formula: multiple IF functions in a cluster shall determine the value and give out a result of a query: =If((Match([Status],"ITEM New","ITEM Open", "ITEM in Analysis", "ITEM Analysis Complete", "ITEM in Implementation") AND ([overdue] ="overdue")),"overdue","not yet overdue")
Columns: [Status] = this is a field that is pulled from the source data and just displayed here. [overdue] = this is a custom field that is added in the table directly (basically a calculated field). The value for this field is calculated using this formula: =if (date([Actual Due Date], 'DD.MM.YYYY')>Today(1), 'good', 'overdue')
Well, the error message does not really help and i have not yet found something in this forum that solves my problem. Can somebody please give me a hand and let me know what i am doing wrong here? 🙂
