-
Contact List, with Upates
I've searched and can't find a solution in the community. New staff members complete a form which includes providing an email address. The email is saved in a Contact List column. So far, so good. Once they are hired and in the HR system, the receive a Net ID, which when combined with the university domain, is their…
-
Formulas for Sheet to Sheet Summary to Dashboard
I'm officially stumped. I'm tracking Admissions Reps visits to schools, the types of visits and the amount of visits and inquiries. The columns are as follows: Created Date Rep Name Type of Event 1 - Dropdown: Tabletop, College Fair, Classroom Presentation, School Visit, School Tour District 1 - Dropdown with all Districts…
-
Formula Error multiple criteria
Hello, I am trying to find the average audit score for a range of percentages between two dates. There are divider rows for organization by month. I have been trying to utilize the following formula but continue to get #DIVIDE BY ZERO for an answer: =AVG(COLLECT([Audit Score]:[Audit Score], [Date of Chat]:[Date of Chat],…
-
Linked Dropdowns in Multiple Columns
I am really enjoying linked dropdowns in Table View (not as in love with Table View overall yet). I have a question that isn't covered in the information: Is it possible to reference the same list twice in the same sheet? I have a pass down log that only supervisors can create. There is a dropdown list for the creator to…
-
Include predecessors in Filter creation
I would love to add the option to include predecessors/dependencies in my filter option (just like the ability to include parent rows - like a little checkbox). This will allow me/my business the opportunity to see what feeds the tasks they are filtering on to see if there is any analysis that can be done to help mitigate…
-
User unable to login - stuck on T&C page
This discussion was created from comments split from: Cannot log in Smartsheet.
-
My data shuttle filtering is not correct in upload
upload workflow runs perfectly, but the filter has projects less than 31st march 2025
-
Multiplying the Values of My Ancestors
Hello, has anyone found a way to multiply the values of the Ancestors for a specific cell together? For example, I'm trying to get the total amount of 31445A113 required for the assembly A-341-10-1-0999. I was hoping to just use the Ancestors formula to multiply the quantity for A-341-10-1-0999 (x2) but the quantity for…
-
Can we publish the timeline view as a read-only HTML?
Is it possible to publish the timeline view as a read-only HTML file for people who don’t have a license? I’d like to share the Project Roadmap in timeline view with everyone at the company.
-
Delete contacts
I want to start over again with my contacts. How do I delete all 1200 contacts without having to do it individually?