Recent Discussions
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
-
First post 05/13/18,Last post 08/05/20I did not see this topic covered: Is there a way to combine logical "AND" and "OR" when creating a filter? The only options seems to be 'All conditions" (AND) or "One of the conditions" (OR) Here is w…Using Smartsheet64214philippejj0421 -
IF(OR) trying to OR 3 expressionsAccepted AnswerAccepted Answer vipa2000 15 views 2 comments 0 points Most recent by vipa2000 Formulas and FunctionsFirst post 08/05/20,Last post 08/05/20From what I can see I should be able to 'OR' 3 expressions, but I keep getting unparseable. =IF(OR([email protected] = "Full Topo including underground services",([email protected] = "Full Topo excluding underground services",(Re…Formulas and Functions152vipa2000 -
Can someone help me get my SUMIF formula to work??Accepted AnswerAccepted Answer Erika Haskell 15 views 7 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 08/05/20,Last post 08/05/20I am not as savvy as I want to be with SmartSheet, but I am hoping someone can help me manipulate this data the way I want to. I am trying to to summarize each individuals resource hours spent in meetings within a certain project. I have c…Formulas and Functions157Erika Haskell
-
Trying to create a simple IF..OR..ISBLANK formulaAccepted AnswerAccepted Answer sbrelage 14 views 3 comments 0 points Most recent by Mathieu PERSICO Formulas and FunctionsFirst post 08/05/20,Last post 08/05/20I'm getting an invalid operation error and I know I'm making a simple mistake but I've tried everything... =IF(AND(NOT(ISBLANK([Launch Date/Prod Release/Go Live)]4)), >=TODAY(-7)), 1) IF the Launch Date/Prod Release/Go Live cell is not …Formulas and Functions143sbrelage
-
Update triggered on completion of a subtaskAccepted AnswerAccepted Answer James Chestnut 17 views 3 comments 0 points Most recent by Genevieve P Formulas and FunctionsFirst post 07/27/20,Last post 08/05/20Hi all, I need some help changing the status of an item to 100% when the first subtask for that Item in another sheet is completed. The working sheet has the following columns and I'm trying to update the "Complete Percentage" co…Formulas and Functions173James Chestnut
-
COUNTIFS formula with a percentage but I need it to round upAccepted AnswerFirst post 08/05/20,Last post 08/05/20Hi I am using this formula =COUNTIF({DA Audit Tracker Range 1}, "Y") / 273 * 100 + "" + "%" It is giving me the right % answer which in this case at the moment is 67.76557%. But I just want it to round up to t…Formulas and Functions102Blayne
-
COUNTIFS with 2 argumentsAccepted AnswerAccepted Answer Manish Govindji 15 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 08/05/20,Last post 08/05/20Hello, I want to count all the open tasks with are less than 1 week due, I have tried to =COUNTIF({Range 1}, "Open", {Range 2}, <7)), the reference sheet have Open and Range 2 has Days left, in number. But i am getting error …Formulas and Functions153Manish Govindji
-
comparing two columns to find blanksAccepted AnswerAccepted Answer Storme Dunn 13 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 08/05/20,Last post 08/05/20I was using countifs:field1,"isnotblank"@cell, field2,"isblank"@cell...that the jist of the formula. Am I on the right track? The columns are names and I need know when someone has entered a name in the "Last"…Formulas and Functions135Storme Dunn
-
Answered - Pending Review alcapps 61 views 5 comments 3 points Most recent by Marilin Campos Using SmartsheetFirst post 06/03/20,Last post 08/05/20Several times a day I get requests to share a source sheet to a user who received an automated alert. Since the body text is small and the source sheet link if big and in a different color, i can understand why they are clicking on it. I h…Using Smartsheet615alcapps
-
Is this possible with any combination of copy/move; index/match, and or cell linking/other?Accepted AnswerAccepted Answer Kevin Smith 19 views 11 comments 0 points Most recent by Paul Newcome Using SmartsheetFirst post 08/04/20,Last post 08/05/20I want to see if it is possible to copy rows from a master sheet in to other sheets and have them sync'd to where the master sheet changes reflect in the rows copied to the other sheets and the changes in the other sheets reflect in the ma…Using Smartsheet1911Kevin Smith
-
Answered - Pending Review Kelly Gabel 15 views 4 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 08/05/20,Last post 08/05/20I am trying to get a count of rows on a sheet that are not Completed AND are not a Sub-Task. My formula works on a syntax level, but it is not coming back with the right answer. Can someone help me figure out what I'm doing wrong? =COUN…Formulas and Functions154Kelly Gabel
-
Workflow not sending emailsQuestionAnswered - Pending Review Gary Norton 67 views 6 comments 0 points Most recent by Daniel Pearson Formulas and FunctionsFirst post 05/17/20,Last post 08/05/20I have a very simple workflow that is not sending email when rows are added. I have been testing with me doing the entry and I don't get emails. My notifications and Automation Permissions are correctly set. Can anyone provide insight or …Formulas and Functions676Gary Norton
-
Answered - Pending Review beth_linder28141 18 views 6 comments 0 points Most recent by Genevieve P Using SmartsheetFirst post 08/04/20,Last post 08/05/20I had responded on a thread a week or so ago but I am still having issues. I cannot select "ok" because it will not stay "blue" and allow it to be clicked. Is there a fix in the works? I think this has been an ongoing…Using Smartsheet186beth_linder28141
-
Answered - Pending Review Anna Kipnis 13 views 1 comment 0 points Most recent by Mathieu PERSICO Using SmartsheetFirst post 08/05/20,Last post 08/05/20Hello, I've created a report containing some numbers. In the underlying sheet the amounts are formatted as a numbers with separators and without digits after coma. Unfortunately in the report the numbers are appearing unformatted. This rep…Using Smartsheet131Anna Kipnis
-
Answered - Pending Review Dan Harris 15 views 1 comment 0 points Most recent by Mathieu PERSICO Formulas and FunctionsFirst post 08/05/20,Last post 08/05/20Hi, Can somebody help? I need to add a column that calculates how many days late tasks less than 100% complete are compared to today see below example, basically need a formula that calculates the 'working days late' column. Thanks fore…Formulas and Functions151Dan Harris
-
Return a sum using using sumifs and datesAccepted AnswerAccepted Answer Larry Bejcar 18 views 4 comments 0 points Most recent by Genevieve P Formulas and FunctionsFirst post 08/04/20,Last post 08/05/20My objective is to return a sum of all 'Work Hours' that are in a department (Wire in this example), that fall within a date range of the 'END' date that Smartsheet is reporting.. This formula returns a value, but I've checked manually, an…Formulas and Functions184Larry Bejcar
-
COUNTIFS IssueAccepted AnswerAccepted Answer Phil2020 24 views 7 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 08/05/20,Last post 08/05/20Hi, I am trying to count between a range of numbers. The problem is smartsheet seems to only count the first number and everything after that. It doesnt seem to count between the range. Range to count is Probability - This has numbers rang…Formulas and Functions247Phil2020
-
Nested IF Statement Help NeededAccepted AnswerAccepted Answer Andrea Whittaker 23 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 08/04/20,Last post 08/05/20(Image) Hi there, Here is what I am trying to achieve: If the % Complete column =100%, then return Gray to the status If a task is overdue (using the End Date column), return Red to the status If a task is due within 5 days, return Yellow…Formulas and Functions235Andrea Whittaker
-
Answered - Pending Review Amy Zeng 12 views 2 comments 0 points Most recent by Amy Zeng Premium Apps and IntegrationsFirst post 08/03/20,Last post 08/05/20Hi An error occurred(picture attached) when I add the Smartsheet in channel files in Microsoft Team. I am the Smartsheet file owner and have allowed the Smartsheet application to be installed as it mentioned here. https://help.smartsheet.c…Premium Apps and Integrations122Amy Zeng
-
today() automatically change or notAccepted AnswerAccepted Answer Yashwant Singh 47 views 17 comments 0 points Most recent by Andrea Vecchi Formulas and FunctionsFirst post 07/13/20,Last post 08/05/20Hi, confused for using Today() formula in my sheet.. Currently using countif and sumif formula based on today() date. please confirm that formula automatically changed when date today() change or when I can manually activate my sheet first…Formulas and Functions4717Yashwant Singh
-
Answered - Pending Review Tamizamuthan Vedachalam 22 views 3 comments 0 points Most recent by Tamizamuthan Vedachalam Using SmartsheetFirst post 08/03/20,Last post 08/05/20Hello, I am trying to pull a column data from a different sheet using CELL LINKING option. However, when there is a data change, CELL LINKING doesn't bring the new data. Note : I am using Data Uploader to retrieve the data with REPLACE opt…Using Smartsheet223Tamizamuthan Vedachalam -
First post 05/10/19,Last post 08/05/20Does anybody know if this post from 3 years ago has been addressed? https://community.smartsheet.com/discussion/new-line-alt-enter-formulas I'm looking to concatenate cells with line breaks. Thanks!Formulas and Functions98423tylermh -
Answered - Pending Review Anna Pelipas 12 views 4 comments 0 points Most recent by Anna Pelipas Using SmartsheetFirst post 07/31/20,Last post 08/05/20Hi. Please help how could I get such a scenario: Trigger: a flag in a cell If the data in another exact cell in this row is equal to the data in another table's cell (that contains the preliminary data, autocopied to current table), then a…Using Smartsheet124Anna Pelipas
-
Cannot log in SmartsheetQuestionAnswered - Pending Review IdoIcan 34 views 11 comments 0 points Most recent by youngdonkey Using SmartsheetFirst post 06/17/20,Last post 08/05/20I have one free license user, she cannot access to Smartsheet with email link or weblink. Every time she trys, it goes to this page, with tag to "I agree to..." click continue, it will not respond. Even with click to "Smarts…Using Smartsheet3411IdoIcan
-
Project look aheadAccepted AnswerAccepted Answer John Kelly 56 views 8 comments 0 points Most recent by Jace Jontz Formulas and FunctionsFirst post 05/26/20,Last post 08/05/20Hi, I am looking to add a widget to a dashboard to show a two week look ahead of a project. I have a project sheet and essentially want to create a formula to check a box, from which I can use to trigger a report.Formulas and Functions568John Kelly
-
Accepted Answer Nikola Djukic 14 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 08/04/20,Last post 08/05/20What I have so far: The box gets checked (true, 1) when a target due date is within 60 days of today. My current formula is: =IF([Target Due Date]3 - 60 < TODAY(), 1) What I hope to achieve: Find a way to uncheck (false, 0) the same b…Formulas and Functions143Nikola Djukic
-
Cascading DropdownsAccepted AnswerAccepted Answer Michael Hair 30 views 3 comments 0 points Most recent by Stacey Harvey Using SmartsheetFirst post 08/04/20,Last post 08/05/20When someone picks an answer from a drop down list in a form, is it possible for the next drop down list to only have choices that relate to the answer from the previous list? For example, when someone chooses between a list of cars (Ford,…Using Smartsheet303Michael Hair -
Quality Control RecordQuestionAnswered - Pending Review Taylor Cartwright 12 views 1 comment 0 points Most recent by Paul Newcome Using SmartsheetFirst post 08/04/20,Last post 08/05/20Hi, I am trying to create a smartsheet to track the quality of a constructed panel. The constructed panel needs to be checked at certain points by different team members. The data needs to be stored to each individual panel. I have tried u…Using Smartsheet121Taylor Cartwright
-
Exporting a dashboard as a PDFQuestionAnswered - Pending Review Victor Micelli 23 views 2 comments 0 points Most recent by lewis hamilton Using SmartsheetFirst post 08/04/20,Last post 08/05/20Hello everyone. Recently I built a dashboard and as we want to keep them saved month after month, I tried to export it as a pdf. First of all, I didn't find the option to do so, so I did it via the printing function. It happens that the qu…Using Smartsheet232Victor Micelli
-
Answered - Pending Review Margarita Takou 14 views 2 comments 0 points Most recent by lewis hamilton Using SmartsheetFirst post 08/05/20,Last post 08/05/20How to populate drop down fields with multiple entries? Is the space between the multiple entries considered a space?Using Smartsheet142Margarita Takou
