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

First post 02/16/18,Last post 02/19/18If cell A3 contains "ABC" then enter "ABC" in cell A1. Can someone help me do this in smartsheet? I tried using =If(find("ABC",A3,)="ABC","ABC","X") but its not working. …Formulas and Functions555Debbie J

First post 02/18/18,Last post 02/19/18Hello, I'm trying to minus days from dates using the following formulas but am getting errors everytime: =NETWORKDAY([Date Printed]8  [Date Dispatched]8)  gives me the error #Incorrect Argument Set =NETWORKDAY([Date Printed]8, [Date D…Formulas and Functions301MariaF

First post 02/17/18,Last post 02/19/18I think I'm close but this is driving me crazy. I have an event code column and two other columns where I am collecting participation data on Saturday and Sunday. I would like to know the total participation for the weekend. The formul…Formulas and Functions161melissa34381

First post 02/18/18,Last post 02/18/18I folks. I think I found an edgecase in your new crosssheet formula system. I wrote some index formulae to pull related data from other sheets when the user chose some options from a list. All was working, and I was able to link, custom…Formulas and Functions121[email protected]

First post 02/15/18,Last post 02/16/18I am working on charting out dev tasks and need to display what our expected total monthly cost would be based on the tasks finished each month. I am struggling to find out a good way to have this either permanently displayed or easily acc…Formulas and Functions351gdavid.theflyer

First post 02/13/18,Last post 02/16/18With the recent expansion of formulas to cross reference other sheets I would love to be able to split projects to other sheets. If I could pull the Primary column and the Start Date column via formula I could have secondary sheets that ha…Formulas and Functions453Thane Knutson

First post 02/16/18,Last post 02/16/18I have an Invoice Smartsheet which has invoice amount for invoices for last several months. I have to calculate month to day invoice amount. I have given the following formula: SUMIF([Inv Amt Rs]:[Inv Amt Rs], [Inv Date]:[Inv Date] > &…Formulas and Functions121Suresh Shenoy

First post 02/16/18,Last post 02/16/18I have a hard keyed number in a cell (113), in cell to right is a formula =COUNTIF(Status3:Status97, OR(@cell = "Active", @cell = "Invited")), resulting in a count of 93. I am trying to subtract the 113 from 93, with …Formulas and Functions941lisa. caldwell37926

First post 02/07/18,Last post 02/16/18As my Smartsheet app has gotten more complex I often try to find ways to simplify sheets and speed things up. The new crosssheet reference capability has me wondering if it would be faster than the existing links when loading a sheet? I d…Formulas and Functions174Jim Hook

First post 02/12/18,Last post 02/15/18Hello, I have a particular problem, I have a series of cells that have formulas to detect the checked values of a series of Check Boxes, creating conditional formatting and inserting 'N/A' in certain cells: =IF([Assemblage Mecanique]8…Formulas and Functions112Paul Charlebois

First post 02/15/18,Last post 02/15/18Would anyone have a example of a formula to count checked boxes in a column divided by the number of unchecked boxes. Any help will be greatly appreciated. Thanks.Formulas and Functions525americansurveymanagement35236

First post 02/14/18,Last post 02/15/18Good afternoon Smartsheet Community: I am trying to add the total from the count of 2 sheets given the criteria. However, I am receiving an INCORRECT ARGUMENT SET when using SUM or Count conditions (formula below). Any help appreciate…Formulas and Functions102KalEl

First post 02/14/18,Last post 02/14/18I have this formula copied down a column: =vlookup(A1,ReferenceAnotherSheet,3). The first row bring back the correct number value. The other rows are bringing back a #nomatch. Also, I want the cell to return the total of all cells in co…Formulas and Functions171DV

First post 02/14/18,Last post 02/14/18I'm trying to write an IF/AND statement that references a range of data in another Smartsheet but an #INVALID OPERATION message is returned. * IF the user is requesting to use the Immersive Learning Center * AND the user is requesting to …Formulas and Functions295Mary Ayers

First post 02/13/18,Last post 02/14/18I use the formula when counting late tasks: =IF(ISBLANK(Finish107), "", IF(AND(TODAY() > Finish107, [% Complete]107 < 1), 1, "")) The issue with this is that it also counts summary tasks which really aren't task…Formulas and Functions123brandon.elmer

First post 02/14/18,Last post 02/14/18To count the number of unchecked boxes I'm using the formula: =COUNTIF([% Complete]3:[% Complete]60, 0). The issue is that it is also counting blank rows. How do I get it to only count actual blank checkboxes? (Image)Formulas and Functions241brandon.elmer

First post 02/12/18,Last post 02/13/18I am attempting to create a project status column that is using the Harvey Balls (red, yellow, green and gray). I am wanting these to automatically change yellow when my due date column is 120 days with the due date, I would like it remain…Formulas and Functions771EvaM

First post 02/11/18,Last post 02/13/18Hello ~ I'm calculating attendance and want to highlight inactive participants. Currently, I copy and paste =COUNTIF([20 1/6/18]3:[25 02/10/18]3, "P") each week as a new column is added. Is there a formula that will auto add ne…Formulas and Functions121Diane Martell

First post 02/06/18,Last post 02/13/18Hi, (Sorry if this has already been asked and resolved, I couldn't find anything). I currently use smartsheet for our team's training log. In doing so, there are several columns that require numerical data that I would like to keep tra…Formulas and Functions143hquinn

First post 02/09/18,Last post 02/13/18Getting an Invalid Data Type error with this formula: =COUNTIF(AND(FacilityCount:FacilityCount, "TZ"),NOT(COUNTIF(Status:Status, "Green"))) The second "CountIf" is a symbols column. Looking to make a count…Formulas and Functions163DanielGD

First post 02/09/18,Last post 02/13/18I'm trying to count the number of late tasks in a project plan. The formula I'm using works as long as a row isn't blank. =IF(AND(TODAY() > Finish15, [% Complete]15 < 1), 1, ""). If I drag the formula all the way down t…Formulas and Functions683brandon.elmer

First post 02/09/18,Last post 02/13/18I'm trying to determine a COUNTIF formula to show what deliverables are due in the next 7 day period based upon a Due Date column. However, I'd like said formula to only showcase what deliverables are in the next 7 days and ALSO be able to…Formulas and Functions322[email protected]

First post 02/12/18,Last post 02/12/18I'm trying to use VLOOKUP for the first time, and perhaps I just don't understand how it all works. I keep getting an "invalid data type" error. Here's my formula. =VLOOKUP(Workorder10, {Platform MPS Range 3}, {Platform MPS R…Formulas and Functions261Mikey67156

First post 02/10/18,Last post 02/12/18I am using VLOOKUP in a sheet (call it Sheet2) to pull data from anotther sheet (Sheet1). Then, I'm creating a report that pulls data from Sheet2. This report is pulling some of the data from these VLOOKUP columns. I'm seeing an issue whe…Formulas and Functions194caroline_allen37286

First post 02/09/18,Last post 02/12/18I can't figure out how to make the function work or I'm trying to do something not supported. Basically, I want to pull the value of a cell from a row on sheet B and put it in a cell on the same row in sheet A. I'm not looking to perform …Formulas and Functions1024joechap

First post 02/07/18,Last post 02/12/18Hello! I am trying to find a way to determine resource allocation in project plans so that they more accurately reflect the availability of my team in the resource view. We have individual project plans for each project, which all fe…Formulas and Functions232ABogle

First post 02/09/18,Last post 02/12/18I'm very confused about how VLOOKUP has been implemented. * Can the search value reference a value in another column in the current row, or can it only be a string enclosed in quotes? If it can only be a string, it makes the function pre…Formulas and Functions322jiwhite

First post 02/11/18,Last post 02/12/18I have a sheet of VLookups which I get to be working perfectly then when I come back later (sometimes as little as 1015 minutes) most cells have been changed to "No Match". To fix this I simply have to reinput the range to what…Formulas and Functions232James Maxwell

First post 02/11/18,Last post 02/12/18I have two columns "Actual Start Date" and "Actual End Date", I want to have a formula for the status column using the RYG Status balls that will:  Red when nothing is in either of the two cells  Yellow when there i…Formulas and Functions151cjustin.grey37336

First post 02/12/18,Last post 02/12/18I'm trying to determine a COUNTIF formula to show what deliverables are due in the next 7 day period based upon a Due Date column. However, I'd like said formula to only showcase what deliverables are in the next 7 days and ALSO be able to…Formulas and Functions121[email protected]