I’m using a FormulaMap to iterate over every row but the one I’m on, so something like
Then I want to go and delete my name from a list. I wanted to use .Filter() but that doesn’t work if my name isn’t on the list. In that case I have to use an IF() statement which gets super clunky. I was hoping something failed gracefully. I tried thisRow-User() but it deletes everything in the column.
Beyond the IF() statement being clunky and looking for something cleaner, I also get an “Unable to execute invalid action” when trying to do a Null result on a FormulaMap, so I had to do another ModifyRows() for a fake column just to make it work. How can I fix that??
ModifyRows(CurrentValue, [Column 3], “good”)))