-
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?
-
Duplicated a Sheet / History is GONE
I duplicated a SHEET and now all of my HISTORY (in cells) are GONE! HELP! I can see the deleted info in the Activity Log and can recreate; however, now it throws and error and won't let me get it back?
-
Editing Features without a license
I would like to understand in which way a user could edit a smartsheet without holding a license for smartsheet.