I am trying the following.
Not sure if the issue is that the Date format items can´t be blank or something on my formula
Hi @JosAngel94
The issue is in "Status = Rejected". It should be Status = "Submission Status".Rejected.
It should refer the list item from your list
Cheers!!
@Himanshu1998
Hello Again,
I tried your way and got the following message :
Circular references: Rep has too many account assignments, Current Assignment Start Date, A4 Account Assignments: Edits Approval Status, Audit Log Submission Filter, User Employee Cancel or Confirm Staging 2, Rep has too much net sales, Pending Account Net Sales, DB Filter, Rejected, Potential Account Net Sales, Active Account Assignments, Account Assignment Max # Staging, Potential Account Net, A4 Account Assignments: Edits Status 2, A4 Account FindItem for Account Assignment DCA, Delete Pending Account Assignments, Approved Account Assignments, Current Rep, Start Date, Reps are missing account assignments, A4 Edited End Date, A4 Account Assignments FNB, Active Account Net, A4 Account Assignments: Status 2, INP/ACC02 - Confirm, Pending Account Assignments, Staging - Remove From Subset?, L5 Accounts: Remove or Confirm, Rep will exceed maximum # accounts, Status, Active?, Total Active Net Sales, CF - Current Status, Approved, Rejected Account Assignments, INP/EMP01 - Unassign All Accounts, Pending Account Net, CF - Assign, Pre-Approval, Users Mapping, Potential Account Assignments, A4 Account Assignments, A4 Account Assignments: Status Change, CF - Error Message, A4 Account Assignment End Date, A4 Account Assignment: By Status, Reps do not have enough net sales, Message, # Accounts Gained/Lost, Rep does not have enough net sales, L5 - Active: Unassigned Accounts, Active Account Net Sales, # Active Accounts, Pending Accounts, L5 Account for Account Overlap, Confirm:, User Employee Cancel Or Confrim, A2 Employee Text, User Employee Staging 4, Delete Removed Rep?, Violates Rule?, Account Net Gained/Lost, Rep does not have enough account assignments, INP/ACC01 - Can Assign, Reps have too many account assignments, Reps have too much net sales, A4 Account Assignments Edits: Approval Status, Assignment overlaps with another rep, A2 Employees: in Account Assignment, Approved Account Net, Error Message, Mail, Pending Account Assignment Edits, Approved Accounts, CF - Confirm, A4 Account Assignments: Approval Status, Pending, Rejected Account Assignment Edits
HEre is the formula Itried: IF Status = Submission Status.Rejected Then Blank Else 'A4 Account Assignments'.Start Date
I also tried this one :
But got the same error. I remember trying this one yesterday but I can´t recall getting this huge mistake message.
It seems that the formula is correct but you are getting circular references error. You'd need to check the line items you are referring in the formula and the line item in which you are applying the formula to resolve this.
Hi ALL, I have a module where a line item (Assignments column) is formatted by a large ‘Projects’ list. Each record is assigned to a Project and this module is published to a UX page. When users apply a filter on the Assignments column, the filter dropdown displays the entire Projects list (since the column is…
Hi ALL, In my model, I have Need stored at a 'D3' RS Group level. I need to use this Need in another module at the G5 Location level. I currently have a mapping module where each G5 Location maps to a D3 RS Group. This Module uses D2 Role as dimension. but the line item I've to find the RS Group (Find D3 RS Group = 'FIND…
I couldn't find any formula to do this, but I want a way to put on the page/grid the connection details. This is so I know what connection I'm in rather than going into Connections details to see it. Is there an XL3 formula to return this value?
