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
Create the Conversation: #CanDoCommunity Event with Carlos WatsonIn The New Work/Life Reality#CanDoCommunity is back! In January 2021, Smartsheet is hosting a virtual #CanDo Community Q&A event with Carlos Watson, CEO & Co-Founder of the Emmy Award and Webby Award winning media company OZY Media. He will be joining us to t… -
Announcement
Update Request Confirmation Email ChangeIn Using SmartsheetHi Community, As many of you know, Smartsheet has always sent a confirmation email anytime someone responds to an update or approval request. Based on customer feedback, we have made the confirmation optional. Each respondent can now opt i… -
Column Formula for Health with check for ParentIn Using SmartsheetI am using the following formula to drive the RYG ball color in a Health column. The color reflected in the Health column is driven by a combination of "Complete" (checked boxes) and "Due Date" data. GREEN = Complete …
-
Weekly Schedule ForecastIn Using SmartsheetCurrently we use Excel to create a weekly scheduled forecast for our scheduling agents to know when they are on break, lunch or in training. I am hoping to replicate that in Smartsheet. Please see the attached current tool. Is there anyw…
-
Risk Heat MapIn Formulas and FunctionsI have developed a risk register using a rating of likelihood and severity to determine 1 of 25 possible risk profiles. I want to provide a visual presentation of the overall risk profile (summary of the whole risk register). In the past I…
-
How do I link QR Codes to Smartsheet linesIn Using SmartsheetThe aim of the project is to attach bar codes to equipment, so when the maintenance folk scan the code it takes them to the line in Smartsheet where the equipment information and Maintenance Plan is located. They can then download & po…
-
How can I lock a cell once it is populated?In Using SmartsheetI have assigned numbers to each of my rows and have created a column to populate the CHILDREN with the number of the PARENT so I can tie the relationship back. For instance, if I close out the CHILD, I want to be able to tell which PARENT…
-
Red / Yellow / Amber formulaIn Formulas and FunctionsHi, Can anone please suggest for my sheet that is formatted as shown in the attached image and for the following conditions if risk/issues cell is not blank and due date is in the future then yellow if past due date then red if past du…Answered - Pending Review 51 views 3 comments 0 points Most recent by Mark C. Formulas and Functions
-
substracting empty cells gives #invalid operationIn Formulas and Functionscolumn 1 & 2: data, column 4: data column 3: =IF(SUM([email protected]:[email protected]) = 0, "", (SUM([email protected]:[email protected]))) so if column 1 plus column 2 equal 0 the cell stays blank. this part of the function works well in column…
-
Pulling data only for current yearIn Formulas and FunctionsI have a metric sheet pulling in data from a pipeline report to show how many closed deals we have for that region from 2016 thru to today. I now need to add a formula to show only the closed deals within that region for 2020 and display…
-
% Complete Average Column FormulaIn Formulas and FunctionsI am currently using a Column Formula to calculate % Complete. The formula is a combination of two checks: Children rows calculate based on a check box "Complete" column. The % complete will be calculated as 0% for an unchecked…
-
Insert approvers name and date/ time of approvalIn Formulas and FunctionsHi all, I have created a form and a workflow for approval. In short: Somone submits a form Details email to an approver Approver either approves or declines (would also be good to have more than 2 options i.e. defer) The smartsheet updates…
