Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
Formulas and Functions
Discussion List
-
VLOOKUP with another sheet with matching dataAccepted AnswerFirst post 01/17/20,Last post 01/18/20Hello, I am trying to do a VLOOKUP from another sheet based on a value in my current/new sheet. I want to MATCH the Task Name column first, THEN go to column 41(old sheet) and enter the date from that column onto my new sheet. This is wh…Formulas and Functions309Jennifer Workman -
First post 01/17/20,Last post 01/17/20I need help basically calculating lead time for a portion of a project. For example to Calculate Planned days I need a formula that would subtract the date the Samples where approved from the date the Mass Production is scheduled for deliv…Formulas and Functions227Chichi
-
SummaryAccepted AnswerFirst post 01/17/20,Last post 01/17/20I am trying to find a way to do a monthly summary of the number items each month in Published, and Expired Alert Status. https://us.v-cdn.net/6031209/uploads/277/JKXO5DMT4B8I.jpg Does anyone know what would be the best way to complete th…Formulas and Functions91Kristie Diersen
-
First post 01/15/20,Last post 01/17/20I have a sheet of active projects. https://us.v-cdn.net/6031209/uploads/900/8XJWC47H1XNC.png I am trying to create a report filter on the Status column. However Status does not show up as a column either in row report or summary report. …Formulas and Functions2511Shawn Borror
-
First post 11/21/19,Last post 01/17/20While trying to figure something else out, I stumbled across a new option for having specific actions date/time stamped using the stem generated Modified (date) type column and the new Copy Row automation. . DISCLAIMER: This does not sc…Formulas and Functions658Paul Newcome -
First post 01/17/20,Last post 01/17/20I am using a content calendar template. All the formulas were already a part of the standard content calendar Smartsheet. We noticed that since the new year (after January 2020), all the dates automatically shifted. The December 2019 paren…Formulas and Functions92Grace_J_Dravenack32331 -
Adding to Formula: 1 out 10AnsweredFirst post 01/16/20,Last post 01/17/20Good afternoon Smartsheet Community: I am trying to add to this formula: =("Priorities for 9/23 Week: " + COUNT(CHILDREN())) I want it to Count the number of Done: Priorities for 9/23 Week 1 out Of 10. ThanksFormulas and Functions226Ray B
-
Sending An Update Request after 30 DaysAccepted AnswerFirst post 01/14/20,Last post 01/17/20Hello! I'm trying to send an update request to be alerted during the following time periods: 30 days after the initial row was added 60 days after the initial row was added 90 days after the initial row was added I have an "entry date…Formulas and Functions218Lauren Ford
-
Parent vs child flagAccepted AnswerFirst post 01/17/20,Last post 01/17/20Hello, I'm wondering whether it is possible or not to write a formula to indicate whether a certain cell is a parent or a child. The sheet I'm working with only has 2 levels, and I'd like to create a column that is able to delineate the t…Formulas and Functions182tgilles
-
First post 01/09/20,Last post 01/17/20Hello, I have two fields in a given row, "Plates Needed" and "Reason for Reorder", that I want the contents of deleted when someone selects the "Remake Complete" checkbox. Is there a way to do this using a for…Formulas and Functions4315Mark Strecker -
Nesting IF, AND, etc. syntaxAnsweredFirst post 01/17/20,Last post 01/17/20I am trying to get a status to report as flagged in certain situations and not others. I need it to be specific, because I have alerts for when the status is flagged and I don't want it to happen when it isn't necessary. Right now I have…Formulas and Functions132rbuckner -
First post 10/29/18,Last post 01/17/20I have a column set as Contact List and the Allow Multiple Contacts per Cell field is checked. I am using COUNTIF statements to count how many people are assigned to the tasks for a dashboard. I am using the formula: =COUNTIF({Project L…Formulas and Functions14726BryanHeft -
Adding people to GroupsAnsweredFirst post 01/16/20,Last post 01/17/20Does anyone know why I am getting this message "Cannot add this user to this group"? I created the group, however it is not letting me add everyone I need to.Formulas and Functions201Leann Gibson -
First post 01/16/20,Last post 01/17/20Context: Please see screenshot attached. Project Manager "Fred" has 2 "active" projects in January: Project 1 and Project 2, which are Children under "Fred". This count of 2 is determined by some percentage of…Formulas and Functions333Sandy Glassberg
-
Embedded links in PlansAnsweredFirst post 01/17/20,Last post 01/17/20I have created a template suite and my project plan has links to other docs within the suite. When "Create as New",the embedded links only link back to the original template suite and not the new files. Is therre a way to make th…Formulas and Functions102Terry Birse
-
Sort functionAnsweredFirst post 01/17/20,Last post 01/17/20Hi, Can anyone help me please - how do you disable/enable sort function in sheets? We have some where you can sort with editor access, and some which you cannot sort with the same access. Many ThanksFormulas and Functions111Jenny McFarland
-
First post 01/16/20,Last post 01/17/20https://us.v-cdn.net/6031209/uploads/547/YN8ETXTSH4TX.png https://us.v-cdn.net/6031209/uploads/880/IG7ANCXHG0K5.png I am using smartsheets to access the availability of team members to appropriately assign tasks. How this works is that our…Formulas and Functions331Shanon Stoklosa
-
Help with formula using YEAR functionAccepted AnswerFirst post 01/16/20,Last post 01/16/20I have a need to count rows where: Issue Type = Story Labels include LND-Product Status = Done Year of Resolution Date = 2020 COUNTIFS({JIRA Tickets Issue Type}, "Story", {JIRA Tickets Labels}, "LND-Product", {JIRA Tic…Formulas and Functions142Pamb10
-
Count distinct Mondays, Tuesdays, etc...Accepted AnswerFirst post 01/16/20,Last post 01/16/20I have a sheet that captures phone queue data by operator and date. Date Operator # Calls Weekday (formula) 1/1 Bob 10 4 1/1 Sue 15 4 1/1 Ralph 10 …Formulas and Functions232MCorbin
-
If Then function neededAccepted AnswerFirst post 01/16/20,Last post 01/16/20I have a column that is "Days to Complete" that is calculated by =ABS((NETWORKDAY([Due Date]1, [Todays Date]1))) But I have another column that is called "Status" which is a drop down list . If I set this column to &q…Formulas and Functions112Allan Segal
-
First post 01/14/20,Last post 01/16/20Hello! Stuck testing out formulas to add a Column [Children Due Soon] that checkmarks if a parent row [Task Name] has any children task is due [Due] in the next 7 days. I've been trying to edit the famous RGB formula for this, but still no…Formulas and Functions3817Maricarmen
-
Countif containing specific textAccepted AnswerFirst post 01/07/20,Last post 01/16/20Hello! I am trying to count to see how often a specific word, in this case a person's name, appears in a range of text. I've looked over similar questions and have started a formula, but I end up with an #INVALID OPERATION error. My for…Formulas and Functions417Daryl Lee
-
First post 01/15/20,Last post 01/16/20Greetings, I'm probably over thinking this but I'm trying to do the following; I have a customer account number column and an area column. I would like to count the total number of unique customer account numbers in [Customer Accounts] tha…Formulas and Functions293Sinema
-
Formula for Calculating DatesAnsweredFirst post 01/15/20,Last post 01/16/20This discussion was created from comments split from: Calculate Future Date.Formulas and Functions283System -
First post 01/16/20,Last post 01/16/20I have instructors going on the field to teach. I would like to generate an automatic email with the link to our Smartsheet form for an Instructor Field Report to be filled out. Is this possible? Thank you! Kitty SandelFormulas and Functions122Kitty -
First post 01/16/20,Last post 01/16/20We are asking for updates to quality documents. The form asks for the document number and the title. Is there way to auto-populate the title in the Form once the number is entered?Formulas and Functions121Pam Grant -
Using Countifs with Date Range and multiple qualifierAccepted AnswerFirst post 01/15/20,Last post 01/16/20I"m trying to create a formula, referencing another sheet, with qualifier of date range, and 'Status' being 'Live' OR 'Ended'. I have this: =COUNTIFS({Test Start Date}, <=DATE(2020, 1, 31), {Test Start Date}, >=DATE(2020, 1, 1)…Formulas and Functions162Brent Allen
-
Matching using Multi-select column valuesAccepted AnswerFirst post 01/14/20,Last post 01/16/20I have the following three columns Idx, Stage and Steps. Steps is a Dropdown Multi-Select column. I want to use the step value from column in another sheet to find which row that step belongs to so I can return the Idx or Stage values from…Formulas and Functions419Frank Falco
-
First post 01/14/20,Last post 01/16/20So I have been looking through the community for a while and have seen a couple solutions mildly similar to what I am looking to do, but can't quite get it right. Feel free to link me to another solution if you feel it would solve this pro…Formulas and Functions359H. Obringer
-
Children rows only for specific columnsAccepted AnswerFirst post 01/14/20,Last post 01/16/20Hi there, I am currently trying to merge two sheets that have been created in my company. One has a list of projects/sales on it the other one has just the hardware for each project/sale. I had tried adding a new child row for each product…Formulas and Functions359Adina Foley
