{"action":"created","issue":{"url":"https://api.github.com/repos/dfinke/ImportExcel/issues/497","repository_url":"https://api.github.com/repos/dfinke/ImportExcel","labels_url":"https://api.github.com/repos/dfinke/ImportExcel/issues/497/labels{/name}","comments_url":"https://api.github.com/repos/dfinke/ImportExcel/issues/497/comments","events_url":"https://api.github.com/repos/dfinke/ImportExcel/issues/497/events","html_url":"https://github.com/dfinke/ImportExcel/issues/497","id":383960191,"node_id":"MDU6SXNzdWUzODM5NjAxOTE=","number":497,"title":"Help - Insert data into cell based on conditions","user":{"login":"pkarunkar","id":44933985,"node_id":"MDQ6VXNlcjQ0OTMzOTg1","avatar_url":"https://avatars3.githubusercontent.com/u/44933985?v=4","gravatar_id":"","url":"https://api.github.com/users/pkarunkar","html_url":"https://github.com/pkarunkar","followers_url":"https://api.github.com/users/pkarunkar/followers","following_url":"https://api.github.com/users/pkarunkar/following{/other_user}","gists_url":"https://api.github.com/users/pkarunkar/gists{/gist_id}","starred_url":"https://api.github.com/users/pkarunkar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pkarunkar/subscriptions","organizations_url":"https://api.github.com/users/pkarunkar/orgs","repos_url":"https://api.github.com/users/pkarunkar/repos","events_url":"https://api.github.com/users/pkarunkar/events{/privacy}","received_events_url":"https://api.github.com/users/pkarunkar/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":10,"created_at":"2018-11-24T05:13:06Z","updated_at":"2018-11-25T23:17:47Z","closed_at":null,"author_association":"NONE","body":"Hi, \r\n\r\nI am trying to insert data into the selected cell based on condition matched on another cell. \r\nAttaching a simple excel for example. \r\nConditions like: \r\nIf TargetDate is not null and Task number is empty , then insert comment \"Enter Task Number\"\r\nIf TargetDate is lesser than Last Modified Date, Then insert Comment \" Please reschedule\"\r\nif TargetDate is between 12/10/2017 and 12/12/2017 , then insert Comment \" Take action\" \r\n\r\nI don't know where to start. Conditional formatting targets to text. but how to do validation and get the cell index and insert data in different column, row index. \r\n\r\nI guess, I may be able to achieve this using com object. but checking if there is a better method here. \r\n[Test.xlsx](https://github.com/dfinke/ImportExcel/files/2612019/Test.xlsx)\r\n"},"comment":{"url":"https://api.github.com/repos/dfinke/ImportExcel/issues/comments/441482976","html_url":"https://github.com/dfinke/ImportExcel/issues/497#issuecomment-441482976","issue_url":"https://api.github.com/repos/dfinke/ImportExcel/issues/497","id":441482976,"node_id":"MDEyOklzc3VlQ29tbWVudDQ0MTQ4Mjk3Ng==","user":{"login":"pkarunkar","id":44933985,"node_id":"MDQ6VXNlcjQ0OTMzOTg1","avatar_url":"https://avatars3.githubusercontent.com/u/44933985?v=4","gravatar_id":"","url":"https://api.github.com/users/pkarunkar","html_url":"https://github.com/pkarunkar","followers_url":"https://api.github.com/users/pkarunkar/followers","following_url":"https://api.github.com/users/pkarunkar/following{/other_user}","gists_url":"https://api.github.com/users/pkarunkar/gists{/gist_id}","starred_url":"https://api.github.com/users/pkarunkar/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pkarunkar/subscriptions","organizations_url":"https://api.github.com/users/pkarunkar/orgs","repos_url":"https://api.github.com/users/pkarunkar/repos","events_url":"https://api.github.com/users/pkarunkar/events{/privacy}","received_events_url":"https://api.github.com/users/pkarunkar/received_events","type":"User","site_admin":false},"created_at":"2018-11-25T23:17:47Z","updated_at":"2018-11-25T23:17:47Z","author_association":"NONE","body":"Cannot bind argument to parameter 'Message' because it is null\r\nSomething wrong with binding  **Write-Verbose  -Message  $cellData** ... \r\nBeyond my level of knowledge though :). Or may be its my syntax issues. \r\n\r\nAs usual, Glad I reached to a point where I could get the data inserted. I may be able to suppress this error in my script. "}}
{"actor":{"display_login":"pkarunkar"}}