Join the Smartsheet Community
Find answers to Smartsheet questions, learn about project management best practices, discuss the future of work management, and get how-to guidance for every Smartsheet use-case from fellow users and Smartsheet experts.
Discussion List
-
Report not filtering out all 100% complete tasksIn Using SmartsheetI have a report to show me all of the tasks that are in progress (not 100% complete) or not started within a timeframe. Therefore, the report is supposed to filter OUT all tasks that at 100% complete. It has been working for over two year…
-
Last Week's ValueIn Formulas and FunctionsHi All, Does anyone know of a formula that can pull the values from an existing column from the week prior using the cell history or activity log? e.g. I can see the value last week in the cell history but I want to pull it automatically…Answered - Pending Review 14 views 2 comments 0 points Most recent by JeremiahHorstick Formulas and Functions
-
Email to Smartsheet to create new row in SheetIn Using SmartsheetI'd love to have a discreet email address tied to a sheet so that I could forward it emails as a way to create new tasks. I can't get force people to use a form so it would sure be handy to just set a rule that forwards to an email address…Answered - Pending Review 14 views 1 comment 0 points Most recent by JeremiahHorstick Using Smartsheet
-
What's wrong with my formula?In Formulas and Functions=COUNTIFS(Position2:Position196, CONTAINS("Medical Assistant", @cell), [Cleared to Return?]2:[Cleared to Return?]136, OR(CONTAINS("No", @cell), CONTAINS("Contingent", @cell)))Answered - Pending Review 20 views 2 comments 0 points Most recent by Mike Wilday Formulas and Functions
-
How to send an alert when a ticket is reassigned.In Using SmartsheetI need the system to send out an alert when the 'Assigned To' contact list field changes to a value other than the current value. I have an Alert automation configured with a Trigger: When rows are changed. And When 'Assigned To' changes …
-
Count by event identifierIn Formulas and FunctionsHey ho, Looking to set up a counter of survey findings for different surveys (i.e. Oct 2018, July 2019, Dec 2020 may all have a count) recorded on one sheet so a dashboard widget will display that number. Ideally the widget can have a sel…
-
Enter date based on check boxIn Using SmartsheetI have a "closed" check box in my sheet. Based on that being checked, I want to automatically fill a closed date in another column. Not sure how to do that. Help! Thanks
-
Using Month/Year in formulaIn Formulas and FunctionsAm I missing an easy way to pull in a count based off month in a chart? For ex. My chart shows July and I would like my formula to count events based off the July name in the chart (@row), I could only figure this out using a month helper …Answered - Pending Review 22 views 3 comments 0 points Most recent by Mark Cronk Formulas and Functions
-
How do I copy and paste hyperlinks from Excel?In Using SmartsheetI have a spreadsheet of bug numbers linked to the bug database. Why can’t I copy and paste from excel to smartsheet retaining the hyperlinks? Seems like a feature smartsheet would have!Answered - Pending Review 303 views 4 comments 0 points Most recent by Andrew Detolla Using Smartsheet