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
Introducing baselines for project management, available now!In Using SmartsheetHi Community, We are excited to announce the launch of baselines - a fixed reference point in time to measure and compare a project’s progress to completion. Capturing and comparing variances between the current actual schedule and the or… -
Announcement
Register now for ENGAGE 2021 Special Edition!In AnnouncementsJoin us online on Tuesday, June 8th from 9-10:30 a.m. PDT for a special virtual edition of ENGAGE! You’re invited to ENGAGE ALL IN, a special virtual edition of our customer conference, where we’ll help business leaders like you unleash t… -
Determine proof dates based on asset lead timesIn Formulas and FunctionsI want to determine a 1st proof due date based on asset type and days to complete. I have another Smartsheet listing all asset types and # of days. I have various columns that list asset choices. when any of these columns have an asset typ…Answered - Pending Review 6 views 3 comments 0 points Most recent by Pam Dunn Formulas and Functions
-
How do I automatically capture the date a dashboard was last updated?In Using SmartsheetHey there, Is there a way to automatically record the most recent date a dashboard was changed? There are several widgets that are present, such as Reports, Rich Text, etc. I have highlighted the area where I'd like to indicate this change…
-
Formula/Summary FunctionIn Formulas and FunctionsI want to be able to summarize how much our locations are requesting in funds, can someone help me with a formula? Column A - Month Column B - Date of Request Column C - Amount Column D - Agency (single select dropdown) Column E - Use of f…
-
How can get the most recently register of FSE from table 1 and send the name of FSE to table 2In Formulas and FunctionsMi situation is that need review int the table 1 who have the 280.1 and once i identify the most recently register need send the name of the FSE who has the 280.1 to table 2 Table 1 Table 2 This I need
-
Auto send a completed form to an email addressIn Using SmartsheetHi, I am fairly new to Smartsheet, and was able to create a sheet and a linked form to replace our old HR blast process. My question is this, I created a form, and we have a list of users who needs to get an update/notified of all fields…
-
Formula Help Countifs and MatchIn Formulas and FunctionsI'm trying to develop a cross sheet formula that will give me an error message if I've over-allocated equipment. This is What I've come up with so far but I get Incorrect argument. =IF(COUNTIFS(MATCH([Equipment Required]@row, {Equipment T…
-
Timed Approval ProcessIn Using SmartsheetI am trying to set up an Approval workflow where if the first approver didn't respond within the first 48 hours, the form needs to go to the second approver. Is there a way to do that?
-
Make my primary column a contact listIn Using SmartsheetHi, I would like to make my primary column a contact list. I know that this is not possible so I tried to copy the whole column using a simple = formula, but as Smartsheet only has 50 cells, this is only a temporary solution. My goal is to…Answered - Pending Review 11 views 2 comments 0 points Most recent by Fritz Schiltz Using Smartsheet
-
Adding 1 day to date in an If formulaIn Formulas and FunctionsHello. I am trying to add one day to a date if the row meets a certain condition. Instead of adding the day, it is putting a "1" at the end of the date string. I have confirmed both the original date and the column with the for…Answered - Pending Review 10 views 5 comments 0 points Most recent by Leibel S Formulas and Functions
