User Profile
CSimms
Copper Contributor
Joined 3 years ago
User Widgets
Recent Discussions
Re: List validation formula for multiple conditions
zeusPH, I should have been more clear in my post. I'm doing it at the list validation settings because I need "Request Initiated Close Date", "Under Review Close Date", and "Case Opened Close Date" to be required fields when the user selects certain statuses. From my understanding the only way to do this is in the list validation settings.10KViews0likes1CommentList validation formula for multiple conditions
Hello, I'm trying to figure out how can I write the formula if I have multiple status drop downs that need to have different columns. For instance: Status "Under Review" needs to display the field "Request Initiated Close Date" and if status "Case Opened" need to display the field "Under Review Close Date" and if status "Resolution in Progress" need to display the field "Case Opened Close Date" I currently have: =IF(OR([Status] = "Under Review", [Status] = "Waiting for Customer"), IF(ISBLANK([Request Initiated Close Date])OR([Status] = "Case Opened", IF(ISBLANK([Under Review Close Date])OR([Status] = "Resolution in Progress", IF(ISBLANK([Case Opened Close Date]) false, true), true))) I've been trying for hours to get this to work but haven't had any luck. Any help would be greatly appreciated.10KViews0likes4CommentsRetrieving version history and adding information to List columns
Good Afternoon, I'd like to display the revision made to items in a SharePoint List column called "Changes Made". Whenever an item is changed, I'm using Power Automate to log the change made in one list and display those changes in another list. Is there a way to capture the version history information and display that info into the "Changes Made" column? For instance, in the version history it displays as: I'd like to display that "Progress" was changed in 3.0 and then in 4.0 "Category" changed1.3KViews0likes0Comments
Recent Blog Articles
No content to show