If I filter a column sometimes, I'm getting duplicated entries. Why is that?
That should only happen if there are duplicated entries in the sheet. Are you able to provide some screenshots for context and maybe more details as to what the problem is?
I've already gone through and removed the duplicated lines, so I have no screen shot to give you. My theory is I'm adding lines in a filtered view, which may also attach to the filter off view as well? Not sure.
I'm not sure I follow. Are you adding rows while a filter is turned on? If so, those lines are in the sheet. They will not be hidden or removed just because you turn a filter off.
Okay... That was what I was wondering, that answered my question. I have other colleagues that have access and work on the same sheet, maybe that caused lines to duplicate somehow, but I'm not really sure. It's probably on our end.
I'm working on a compensation request form that follows these steps: An HR Business Partner completes the Compensation Request Smartsheet Form that then triggers an alert to our Compensation Manager. Our Compensation Manager will insert the requested information. The HR Business Partner will be alerted when the…
I have many many sheets where column names are the same but data types are different (ex: some "Assigned to" columns are text/numbers and some are contact list, some "Project Name" columns are text/numbers, and some are dropdown list.) The choices in value type are driven by the many teams specific needs. This creates…
Is it possible to format a singular cell in a sheet to total the above numbers add in each cell of the column.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.