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 Functions333UWSOMEQI

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 Functions181Jessica.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 Functions25APotter

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 Functions415Jaye 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 Functions195dave.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 Functions2625erober01

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 Functions995BTMarketingOps

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 Functions23Elie

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 Functions144drodgers

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 Functions126MikeChap

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 Functions381[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 Functions265GWilkins86876

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 Functions883Lisa 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 Functions4235Hawk

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 Functions131JOHNJOHNSON86786

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 Functions177Neisha 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 Functions10411steve50951

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 Functions152laurie.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 Functions21Chi

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 Functions1154Tiffany 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 Functions173mrsbrackett

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 Functions1912dcabras

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 Functions312Jamie 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 Functions877steve50951

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 Functions407Tiffany 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 Functions298jsteele86441

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 Functions82dennis.goudy72296

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