Formulas and Functions
Archives for January 2020
Discussion List
-
Answered - Pending Review Sldollman 224 views 11 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/31/20,Last post 02/03/20I'm attempting to create a metric that counts the number of installs in the current month (and also another for those in the current week). I have tried the following: =COUNTIF({Master Range 1}, =MONTH(TODAY())) =COUNTIF({Master Range 1},…Formulas and Functions22411Sldollman -
How to count number of cells in a rangeAccepted AnswerAccepted Answer SuzanneH 28 views 4 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/31/20,Last post 02/03/20Hello, I have two questions about counting the number of cells in a range? How do I count all cells in a range, whether or not they have a value in them? COUNTM seems to exclude blanks. Can I do they same for a list that is not a range? T…Formulas and Functions284SuzanneH
-
Calendar HeaderQuestionAnswered - Pending Review Lori Schefstad 12 views 3 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/31/20,Last post 02/01/20Hello there, I am trying to create a calendar view that shows holidays for 4 different locations around the globe. I've populated the grid with all of the holidays for each location and they are showing just fine on the calendar. But i w…Formulas and Functions123Lori Schefstad
-
Answered - Pending Review Robert Cybulski 251 views 2 comments 0 points Most recent by Robert Cybulski Formulas and FunctionsFirst post 01/31/20,Last post 02/13/20Before I go into specifics, maybe the simplest form of my question is: can I somehow mimic the functionality of LiquidPlanner's "Smart Schedules" in Smartsheet? (Just to clarify, my company doesn't have LiquidPlanner nor does it …Formulas and Functions2512Robert Cybulski
-
Answered - Pending Review MaryEllen Westreich 47 views 1 comment 0 points Most recent by [email protected] Formulas and FunctionsFirst post 01/31/20,Last post 02/01/20I'm trying to get a count of rows between two dates AND where we have the status as one of three choices. I've tried using the OR logic embedded in the COUNTIFS formula, but I couldn't get that working. Instead, I created a helper column n…Formulas and Functions471MaryEllen Westreich
-
Returning Max Date from Another Sheet with ConditionsAccepted AnswerAccepted Answer Lauren Acker 55 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/31/20,Last post 01/31/20Hello, I am trying to gather the max date from a row on another sheet if that row has a matching cell to one on the current sheet. Below is a screenshot of the current sheet. I am trying to fill the Last Action Date cell if the Originating…Formulas and Functions553Lauren Acker
-
SUMIFS with multiple criteria in multiple columnsAccepted AnswerAccepted Answer Donna Claes 36 views 5 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/31/20,Last post 01/31/20Hi - I'm trying to create a formula that will sum the amount of hours in one column when it meets a certain criteria (type of hours) from another column, but only if they were accrued after a certain date (a third column). No matter what I…Formulas and Functions365Donna Claes
-
Answered - Pending Review Andi Hawes 23 views 1 comment 0 points Most recent by Genevieve P Formulas and FunctionsFirst post 01/31/20,Last post 02/03/20Dear Forum, i would like a SUMIFS formula to be able to count hours in my timesheet on certain dates. All my hours and dates sit in one sheet, id like a second sheet to then count hours in certain dates. As i understand it, SUMIFS needs:…Formulas and Functions231Andi Hawes
-
Conditionally changing cellsQuestionAnswered - Pending Review Scott Rae 53 views 10 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/31/20,Last post 07/08/20Hi, I'm looking to see if there is any formula(or anything else) I could use to change a cell to a specific pre-defined value, if a different cell is CHANGED TO a certain value. I know that the changed to functionality is available through…Formulas and Functions5310Scott Rae
-
Turning symbols into a percentageAccepted AnswerAccepted Answer Laura_Murphy 34 views 2 comments 0 points Most recent by Laura_Murphy Formulas and FunctionsFirst post 01/31/20,Last post 01/31/20I have a parent row where I would like to show the % of ticked answers for all the children rows . I can see that the tick is formatted as 'YES' but i can not work out the formula to change the yes into a number to get the %? (File)Formulas and Functions342Laura_Murphy
-
Answered - Pending Review Chichi 23 views 4 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/31/20,Last post 02/03/20I download a time tracking form from smartsheet, but however I have 2 issues. The table for some reason does not have the dollar sign attributed even though i'm using this formula =VLOOKUP(Activity1, $[Task Name]$5:$Activity$10, 2, false)…Formulas and Functions234Chichi
-
IS AND ORAccepted AnswerAccepted Answer Stavros_McGillicuddy 21 views 7 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/31/20,Last post 02/05/20=IF(AND((([Asset Type]113 = "Success Story"), OR([Asset Type]113 = "Video - Client")), Ancestor113 = "2"), "1") Trying to populate "1" where Asset type = Success Story OR Video - Client AN…Formulas and Functions217Stavros_McGillicuddy
-
Week number @row functionAccepted AnswerFirst post 01/31/20,Last post 02/17/20(Image) Is there a more efficient way I could write this formula? I'm looking for the week number and I physically have to go in and change it for each cell. I would like so I can just copy down the formula. Also, a more efficient way to …Formulas and Functions795ginamt3
-
How do I include Contact List Columns in Concatenation?Accepted AnswerAccepted Answer DaveyJones13 74 views 4 comments 0 points Most recent by Jayesh Nathani Formulas and FunctionsFirst post 01/30/20,Last post 02/04/20I need to create a primary key on a page that includes 3 text columns and 1 contact list. The formula errors when I try to include the contact list, but works fine without it. Is there a way to reference a contact column as text or get it …Formulas and Functions744DaveyJones13
-
Answered - Pending Review Peta 43 views 3 comments 0 points Most recent by Jayesh Nathani Formulas and FunctionsFirst post 01/30/20,Last post 02/04/20I require assistance please to create a formula based on two criteria: COUNT "SPI Quoted Value" column, when >0 and when "Date" column CONTAINS or FIND "January" Therefore if I only selected the first six r…Formulas and Functions433Peta
-
Accepted Answer Pam Grant 27 views 2 comments 0 points Most recent by Genevieve P Formulas and FunctionsFirst post 01/30/20,Last post 02/03/20When requesting an approval, I want to be able to send the decision to "contacts in a cell" and cc a "specific person". It appears I can only choose "Specific People" or "Contacts in a Cell" when det…Formulas and Functions272Pam Grant -
Answered - Pending Review Tracy Davis 28 views 2 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/30/20,Last post 01/31/20I have two columns I'm trying to reference in my formula, a check box column (Done) and a date column (Complete Date). Depending on the data in those two columns, I'd like a third symbol column update to Green, Yellow or Blue. The desired…Formulas and Functions282Tracy Davis -
Answered - Pending Review Paru Radia 63 views 2 comments 0 points Most recent by Paru Radia Formulas and FunctionsFirst post 01/30/20,Last post 01/31/20Hi, I have a VLOOKUP formula in my sheet, and it was working for days... then today I got a bunch of "#NO MATCH". I repasted the formulas and refreshed all sheets and re-saved etc... This fixed some of them but I still have many …Formulas and Functions632Paru Radia
-
Formula to Count Check Boxes in a Check Box ColumnAccepted AnswerAccepted Answer dskpetersen 89 views 5 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/30/20,Last post 03/21/20Trying to count in coumns how many boaxes are checked per column - Keep getting Boolean Expected. There are the formulas I have tried: =COUNTIFS([Mike M]5:[Mike M]135, 1) =COUNTIF([Mike M]5:[Mike M]135, 1) Is it possible to created this …Formulas and Functions895dskpetersen
-
Health RGY FormulaAccepted AnswerAccepted Answer Maria Watters 35 views 2 comments 0 points Most recent by Maria Watters Formulas and FunctionsFirst post 01/30/20,Last post 01/31/20Hello All, Our team has created the below formula which worked UNTIL we added the bolded part below. We cannot figure out what is missing and we keep getting an #Incorrect Argument Set error when we change the End Date to be anywhere betw…Formulas and Functions352Maria Watters
-
Accepted Answer Ann Foley 53 views 2 comments 1 point Most recent by Ann Foley Formulas and FunctionsFirst post 01/30/20,Last post 02/03/20Hi, I have a report that I will be data dumping into monthly (1st pic called "Jan GSS"). I created an Index/Match formula (in second pic) to pull those numbers over into my main sheet (GSS ITRec column): =INDEX({Jan GSS ITR}, M…Formulas and Functions532Ann Foley
-
Rows Moved Not Showing in End SheetAccepted AnswerAccepted Answer Jenna Corso 15 views 3 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/30/20,Last post 01/30/20Hello, I've set up a workflow to move rows from one sheet to another after a date is reached. They are being removed from the source sheet, but they are not showing up in the end sheet. I have no idea where they may be going. Has anyone…Formulas and Functions153Jenna Corso
-
Answered - Pending Review Megan Faulkner 34 views 5 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/30/20,Last post 02/05/20Hi all! I am making a registration form for students who will be attending a summer camp. Because they are minors, we need agreements (I am structuring these in a simple "check the box if you agree to the code of conduct" format …Formulas and Functions345Megan Faulkner
-
Answered - Pending Review Ann Foley 45 views 5 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/30/20,Last post 02/05/20Hi, I have one formula that I need applied to all of my parent rows (in this case, property name) and another formula applied to all of my children rows (the score corresponding to each month). How can I automatically apply these formulas…Formulas and Functions455Ann Foley
-
Answered - Pending Review Zafar Yuldashev 64 views 8 comments 0 points Most recent by Dora Berky Formulas and FunctionsFirst post 01/30/20,Last post 02/13/20Dear Smartsheet community members, I need your quick support please. I am trying to pull the data from a sheet which is filled by operations team to the annual plan sheet. The task is to pull the actual contract values from Sheet of oper…Formulas and Functions648Zafar Yuldashev -
Answered - Pending Review System 24 views 2 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/30/20,Last post 01/30/20This discussion was created from comments split from: Count of cells in a date range.Formulas and Functions242System -
Count of DatesAccepted AnswerAccepted Answer lesmickin 13 views 3 comments 0 points Most recent by Paul Newcome Formulas and FunctionsFirst post 01/30/20,Last post 01/31/20I am trying to do a count for everything that has a date prior to 11/01/19. =COUNTIFS([Date Referred to CRU]:[Date Referred to CRU], "<""11/01/19") but i keep getting an unparesable messageFormulas and Functions133lesmickin
-
COUNTIFS with multiple criteriaQuestionAnswered - Pending Review System 80 views 2 comments 0 points Most recent by Alejandra Formulas and FunctionsFirst post 01/30/20,Last post 01/30/20This discussion was created from comments split from: COUNTIFS function with multiple criteria.Formulas and Functions802System
-
IF statement to capture text stringAccepted AnswerFirst post 01/30/20,Last post 01/30/20Hi all In my 'Assigned To' column, I may have several contacts. One type of contacts are all called 'ID<something>' (ID1, ID2, ID3 etc). I need to write an IF statement that identifies and returns all the IDs listed in the Assigned…Formulas and Functions121LisaB:-) -
Answered - Pending Review Daniel Kunkel 22 views 3 comments 0 points Most recent by Daniel Kunkel Formulas and FunctionsFirst post 01/30/20,Last post 01/31/20Dear community, I hope somebody can help me with what I believe is a pretty tricky problem. I have a table that contains line items with many columns, but only 3 of them I am interested in for this use case. It looks like this: Column 1…Formulas and Functions223Daniel Kunkel
