Trouble Using 'Find Duplicates' Formula: What Am I Missing?

System

System Employee

08/12/24 in Smartsheet Basics

This discussion was created from comments split from: Find Duplicates.

0 ·

Answers

SamprasFederer ✭✭

08/12/24

Hi all,
I am just wondering if the column "Find Duplicates" should read 1 on the 2 rows that I screen captured?
tried =if(countif([Ref. No.]:[Ref/ No.]. [Ref. No.]@row)>1,1), that didn't work too!!! Am I missing something?
Thanks guys.

0 · Share on Facebook Share on Twitter

Categories

Trending in Smartsheet Basics

Rolling-up information from sheet and reports. Unable to group information.
I am creating a report that pulls data from sheets and one other report. The information rolls up fine from both the sheets and report but it does not allow me to group the information from the report. For example, I want to group by program and then sub-group by sub-project. I keep getting a "Blank" for the group and the…
Is it possible to remove a cross sheet reference when a condition is met and keep the data?
I have an interesting scenario where I have a cross sheet reference that pulls a current outstanding total from another sheet. This works perfectly but we want to keep history of what this total outstanding value was at the end of each day. The image below should help explain the scenario. Essentially what I want to do is…
Automation: Send to contacts in a cell
I'm building an automation to send a reminder to contacts in a cell but it doesn't let select the cell with a dropdown. Is there a workaround?

Help shape the future of Smartsheet.
Share your ideas and feature requests.