Sheets
Discussion List
- Hello I need to add multiple columns that allows us to input the "on site date", - "Manufacturer Lead time" - "Drawing Approval" = Drawing start Date. Screenshot as below. Appreciate any help to solve…
- We have a form where new employee data is entered, which auto-populates a dashboard smartsheet. What I'd like to do is have a new smartsheet using the data from the new row in the dashboard to create …
- I have added %Complete Column correctly, however % Sign not being displayed correctly for Parent Row, see screenshot. Total for Parent must be 100% Instead of 1 How to correct it?
- I am looking for a way to determine when a value in a child row is unqiur from values in other children (in the same parent). EXAMPLE: I have a sheet with four courses. A course may have children if i…
- Is there a way (or an add in) to drag or attach photos directly from Google photos to the attachment window in a sheet? I know I can upload from a Google drive but that requires me to save my photos t…
- I'm trying to merge data from 2 sheets onto 1 sheet or even a report. I don't want to have duplicate rows w/ the same primary column though. I want all the data for the same Primary column value on ea…
- Hi there, I'm looking to count the number of unique IDs in another sheet I'm referencing (that I cannot edit), and put the count by each ID in another sheet I'm using. I'd appreciate any tips that cou…
- Smartsheet has been a wonderful tool for my team since 2015. A couple things (out of many) I like are the quick sorting options on a sheet and the easy report configuration. With one nusiance exceptio…
- I am using the following formula in Sheet 1 to collect a list of CRNs (course registration numbers) from Sheet 2 (the ranges in the formula reference columns in Sheet 2):: =JOIN(COLLECT({AutomatedCour…
- I have a shortcuts widget on my dashboard. This contains links to Smartsheet items as well as other useful links. When a user clicks on the link, the linked window appears but it cannot be resized. As…