hello all,
I would like to use Data Shuttle to offload the list of "submitted by" users and then upload it to another sheet to count the number of submissions per user.
Source sheet:
Metrics sheet:
How could I prevent duplicate names from being uploaded to the metrics sheet? I tried to use a helper column in the source sheet with this formula to set the unique name to 1 and the repeated name to 0, so that I could add a filter in Data Shuttle to skip rows with 0.
=IF(COUNTIF([Submitted By]$1:[Submitted By]@row, [Submitted By]@row) = 1, 1, IF(COUNTIF([Submitted By]$1:[Submitted By]@row, [Submitted By]@row) = 2, 0, 0))
However, I am unable to convert the helper column to column formula because of the "$" in the formula. In this case, I am uncertain if a new request (added in the top row) can take the formula since it is not a column formula.
Any suggestion?