Comments
-
@Genevieve P. Yep, that did the job, thank yoooou! :-) @AravindGP Thanks again, I very much appreciate the help.
-
Thanks so much but something very odd happened. It's considering the user 1104825 as a new user. Note that the user name is added via API and the user cell is fed the string "1104825", which ends up as '1104825 in Smartsheet. I wonder if that's what is causing the issue.
-
@AravindGP I realise it is off topic but any tips on how to achieve the formula to identify duplicates in the helper sheet? The rest is sorted as you suggested but I have no idea how to implement that part. Thank you.
-
That could work, thanks heaps Aravind. I'll try and implement that.
-
I'm interested in this as well. I've been doing lots of research and it seems Smartsheet can't return multiple values in multiple rows without some workaround that ends up not worth the effort to keep it running. I'm a bit disappointed to be honest as these are simple things we can achieve in Excel and Google Sheets.
-
Thanks for the reply, Aravind. That definitely looks like an option I can use. Do you see any way to avoid the manual intervention when another user is added? We currently have a large number of users and high turnover, which means I'll have new names turn up very often and I'm expecting it to be hard to spot the missing…