Formulas and Functions
Archives for April 2019
Discussion List

First post 04/30/19,Last post 05/01/19I have entered the following formula into a text/number column and I'm getting an unparseable error. I have checked the that column headers are spelled correctly. =IF(AND([% Complete]2 < 1, TODAY() >[Finish]2), "At Risk",…Formulas and Functions403UWSOMEQI

First post 04/30/19,Last post 04/30/19I am trying to count the Stars that are checked across multiple sheets. I can’t seem to get a formula to work. Would anyone know?Formulas and Functions231Jessica.Kelly53216

First post 04/30/19,Last post 05/08/19Hello Smartsheet Gurus, I have a spreadsheet that has a few columns as checkboxes, but when the checkbox is not needed, I want the cell to show nothing. Is there a way to do that? Thanks, ArrynFormulas and Functions15APotter

First post 04/30/19,Last post 05/03/19Seeking some advice on how to make the LARGE function play nice with criteria and possibly, I'm thinking, the COLLECT function. Here's our set up: "Master project sheet" with: 1) "Project name" column 2) "2019…Formulas and Functions625Jaye Tatone

First post 04/30/19,Last post 04/30/19Hi I am trying to create a formula that count all entries by a certain person within the last 30 days. This is a cross sheet formula and seems to work well. Now comes the however! I have the below formula which does the calculation, howe…Formulas and Functions285dave.mcpherson56751

First post 04/30/19,Last post 05/02/19Hi all, I'm having a lot of trouble joining cells that contain a certain value (because there is no contain function). I have a range of cells that are all in a single row, and I'm trying to collect all of the cells that contain a certai…Formulas and Functions5085erober01

First post 04/30/19,Last post 05/02/19I am trying to build a formula that searches in a column for a certain word using the IF(FIND formula but I would like to add in an OR to that. So I would like to use this function: =IF(FIND("Design", [Project Description]4) >…Formulas and Functions2325BTMarketingOps

First post 04/30/19,Last post 05/01/19Hello, My team is tracking hours spent on assigned tasks. We have our SpartSheet set up with: Parent Row : Date, and Total Hours spent for Child Rows Child Row: Team Member, and Hours spent I am looking to see if its possible to ge…Formulas and Functions43Elie

First post 04/30/19,Last post 04/30/19I am trying to create a countifs formula that would count "New Quotes" with a January date while it's referencing another sheet. New Quotes would be in the New Quote/Repricing column of this spreadsheet and then there's the Pr…Formulas and Functions164drodgers

First post 04/29/19,Last post 04/29/19Kind Sir/Madam, Greatly appreciate any help on the following: I created an extra sheet with formula's so I can have them displayed in a dashboard without having to add all kind of formulas and outcome of these formulas in my source …Formulas and Functions116MikeChap

First post 04/29/19,Last post 04/30/19I'm building a sheet for a department who wants to track monthly revenue/expenses and have those numbers roll into YTD columns. (moving them into Smartsheets and out of Excel) Each month has 2 columns Actual & Budget, i want to set up…Formulas and Functions591[email protected]

First post 04/29/19,Last post 05/01/19I have an end user I am trying to build a records sheet for and I can't figure out how to accomplish a change count cleanly. We have thousands of rows/records in a sheet with one of the fields/columns being a Status.They do a monthly revie…Formulas and Functions355GWilkins86876

First post 04/29/19,Last post 05/01/19Trying to get data from one sheet to another by matching on Deal ID to the Requests sheet from the Salesforce sheet Could someone please help me for the formula for this? this would be an import from salesforce that I would have t…Formulas and Functions2343Lisa Bruce

First post 04/29/19,Last post 05/03/19Say that I want to count how many cells with BLANK in a column? The column have many NOT BLANK values also. eg. ([Col]2 with BLANK value) Col row_1 a row_2 row_3 a .... row_n a so the column has 1 cell with BLANK, th…Formulas and Functions9875Hawk

First post 04/27/19,Last post 04/29/19How can I display the bottom (last entered) value of a column in a different "cell" (Image)Formulas and Functions141JOHNJOHNSON86786

First post 04/26/19,Last post 06/07/19Hi All, I am trying to create a formula (assuming a combo of if/or is the way to go), but keep getting "incorrect argument set. They work independently, but not when I combine them. I basically want to search for either of the fol…Formulas and Functions297Neisha Fredericks

First post 04/26/19,Last post 05/06/19Hello, I am looking for some assistance with how to write a formula that will autofill a check box. I only want this checked if the Parent Cell column is blank and that the Assigned to is equal to the user. Currently, the formula I u…Formulas and Functions153Katye Reed

First post 04/26/19,Last post 05/01/19I am trying to write a formula that will calculate receipt totals by month (starting this month) Here is the formula i am using, but it is returning an invalid data type =SUMIFS({Joseph Nelums CRS Expense Reporting Receipt Total}, {Jose…Formulas and Functions15411steve50951

First post 04/26/19,Last post 04/30/19Help! Trying to get a count if line items that do not have a column marked resolved and have a issue type of Reports Missing. =COUNTIFS({Aimbridge Report Issues Range 2}, "Reports Missing",{Aimbridge Report Issues Range 2}, 0…Formulas and Functions232laurie.sather47706

First post 04/26/19,Last post 04/26/19Hello, I am trying to optimize this formula, do you have any idea? Thank you Chi =SUMIFS({Line Value}, {PE}, [PE Project Engineer]@row, {Status}, " ", {Backlog  Sales Orders  RTM Status}, <>"Complete") + SUMI…Formulas and Functions31Chi

First post 04/25/19,Last post 04/30/19Hello, I'm trying to use a COUNTIFS formula to count the number of VLOOKUP errors in another sheet that occur in the past month. From what I can see in other discussions the IFERROR and ISERROR functions are generally used to give a 0 val…Formulas and Functions2414Tiffany White

First post 04/25/19,Last post 04/26/19I'm struggling to figure out how to combine two formulas. Context: my team doesn't like to think in hours, just general size of a task (S, M, L,) so I've created a helper column where each value relates to a number (XS = 1, S = 2, M = 4,…Formulas and Functions223mrsbrackett

First post 04/25/19,Last post 04/25/19Greetings I'm struggling with the crosssheet referencing and need some help with a formula. I want to create a new sheet summarizing the values on a corresponding dropdown menu for the name and # of products we sell. I'd like the total n…Formulas and Functions121btheede86566

First post 04/25/19,Last post 04/30/19Hi all I have a sheet that I use to track recruitment activities within our team. Each role is assigned to a member of the team and has a recruitment status attached to it. I am trying to pull this information into my dashboard to show ho…Formulas and Functions2712dcabras

First post 04/25/19,Last post 04/25/19Hi, Is there a way to find duplicates when a column may contain multiple product numbers which are comma separated? I was able to get the below formula to flag red when only one event number is duplicated in a one to one ratio, and also …Formulas and Functions462Jamie Null

First post 04/24/19,Last post 04/26/19I created a form to capture data into a sheet. i have the form sending new info to the bottom of the form. when the data comes in from the form it puts the rows below the formulas, so the formulas are not applied. It's a sum formula, so i …Formulas and Functions1537steve50951

First post 04/24/19,Last post 04/25/19Hello! I'm trying to track tasks that are completed after the due date. I used this formula to indicate when an task was past due and not complete but once the task is checked off as complete it no longer works, well it works it just does…Formulas and Functions767Tiffany White

First post 04/24/19,Last post 04/25/19I have a sheet where I want to add 30days to another cell that is a date. I am using the formula: =(original date cell) + 30 Example: The original cell has a date of 3/19/19. I should get 4/18/19. However, I'm getting 3/19/1930. …Formulas and Functions448jsteele86441

First post 04/24/19,Last post 04/24/19O.K. I have now inserted my formula to calculate a number of miles driven for a given trip. But now I want to copy the formula to the entire column. Right now the formula is just in row 1 of my SS and I know that I can grab the corner of…Formulas and Functions142dennis.goudy72296

First post 04/24/19,Last post 04/25/19Duh!! I figured it out. It was simple. DennisFormulas and Functions141dennis.goudy72296