Recent Discussions
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
-
Announcement
Are you an administrator for ServiceNow? We'd love to learn from you!In AnnouncementsHi there! Do you administer Service Now in your job? Our team of UX researchers would love to chat with you. We are looking for people to join a 1-hour research session with one of our researchers. We want to talk about how Service Now and… -
Set the Current Date with Record a Date ActionIn Formulas and FunctionsHow can I set the automation so that it only records a date in the row that is being updated? At the moment it is updating every row in the sheet when a single row is being updated. https://help.smartsheet.com/articles/2481986-set-the-curr…Answered - Pending Review 11 views 6 comments 0 points Most recent by James Larsen Formulas and Functions
-
Setting Easy Workflow for Leadership with Dynamic View, Should I try Work Apps?In Using SmartsheetHello, We have created a Centralized Employee Data Sheet. This sheet has each employee by row, with columns that list all of their HR Data, including Performance Review and Compensation Review Questionnaire Responses. Questions go out to E…
-
Excel Form. works well but not in Smartsheet =COUNTIFS(Q:Q,"<>*/*/*",Q:Q,"<>",Q:Q,"<>Complete")"In Formulas and FunctionsAnswered - Pending Review 5 views 1 comment 0 points Most recent by Meredith Krueger Formulas and Functions
-
formula like MAX, but that grabs the top three?In Formulas and FunctionsI have a sheet that collects project updates per project, and I want to surface the most recent three updates per project for a report. So the data is really simple, there is a date and an incrementing autonumber, so I can use either of th…
-
Trying to get a list of distinct values across multiple columnsIn Formulas and FunctionsHello, I have a list of providers. Each provider can list up to 4 languages spoken at their office. I would like to get a list of distinct languages for the entire list of providers. Language 3 and Language 4 have different languages fur…
-
Any method to poll many sheets, without using a collector sheet which requires constant updating?In Using SmartsheetEach of my projects has a Task List. And I need to send open tasks to my users who have open tasks. I accomplish this with a collector sheet that uses COUNTIFS to look at each Task List and identify who has open tasks. That sheet then has …
-
Project Sheet -- Dependencies reportIn Using SmartsheetWe have project plans that are 1000+ lines with multiple functions/workstreams involved. There are hundreds of dependencies. Instead of clicking on every task to see what the dependencies are, I would like to have a report or a way which w…Answered - Pending Review 50 views 4 comments 0 points Most recent by James Keuning Using Smartsheet
-
Request an Update WorkflowIn Using SmartsheetI don't get why the Request an Update workflow does not have a "Save Response in" option similar to an approval workflow. Upon decline, I want the response of the approver (ie the reason for the decline) to be recorded to a spec…
-
Can you link dependencies across sheets?In Using SmartsheetHave a house build, and a garage build. All one project but now it would be more elegant to have 2 sheets, one for the garage and one for the house - but there are some joint dependencies. So I would like to be able to name a row as a depe…
-
Approval Decline WorkflowIn Using SmartsheetHi, Here is the workflow I am using. -Fiscal Monitor - creates a requisition and sends approval notice to Fiscal Manager -Fiscal Manager has to reject with a comment in his/her email/SS notification (via the form generated in a Request an …