-
Best Practice
Good morning, We have an expense report that I pull from our system 2 times a month and put into Smartsheet. I have about 100 Department IDs I share it to split between different 10 bureaus and 4 centers. I am trying to find a good way of splitting up the information. Currently I have 10 grids for the different bureaus…
-
find manually entered duplicate lines
I have a sheet that contains practice-name, practice-seq,and coach-id. I have somehow added multiple exact duplicates. there are 8500 entries so its hard to find them….is there a report I can run to just show eact dups?
-
Rich Text formatting in cells
I would love to see rich text formatting be available in cells on a sheet. We have several reports where we rely on certain words in a cell to be a different color than the other words in a cell (quickly showing variable options or redlining changed content if only a word or two has been altered). Currently, we are only…
-
Will Table view eventually totally replace Grid view?
Is it in Smartsheet's roadmap to stop adding functionality to grid view and only add new features and functionality to table view? Is the long-term plan to make grid view obsolete?
-
Dynamic dropdowns - Waterfall request
The Contact List, Dropdown (Single Select), and Dropdown (Multi Select), are useful tools to control data entry. The problem is they require a lot of maintenance. Through Bridges, we have a sheet that is populated with information from our ADP. It contains all of our employees. Using a Contact List column and selecting the…
-
Issue with WorkApp Attachments?
Is anyone else experiencing problems with users not being able to add attachments to sheets or reports in WorkApps? Users that gain edit access to sheets and reports to edit and attach documents stopped having that ability late yesterday.
-
WorkApps Attachments Disabled
Has anyone seen this in WorkApps? Anyone know what's going on?
-
Published Sheet - Users Unable to add Attachments
I have a sheet for which I've provided a publish link to many unlicensed users. They use the sheet to attach files to rows. This has been working as expected for multiple years previously, but today, we've discovered it will not allow them to attach files to rows and they're met with the message "This action has been…
-
Parent/ Grandparent Cell Value
Hello- I am looking for a way to make every row return the same value as the highest level of its hierarchy (usually just children and grandchildren). I want it to report the top row in a column. In this example, I want all of these rows to return the value "Top Line" in a column.
-
Finding Next Closest Date of Children
Ok hive mind - I haven't been able to talk this formula out with someone yet, so I am looking for a little help. I have the formula that will fill out the children of my FINAL DATE column, but to fill out the parent row, I want my formula to look at the children of the NON REFUNDABLE DEPOSIT column, and tell me what is the…