Formulas and Functions
Archives for April 2018
Discussion List

First post 04/30/18,Last post 05/01/18I am getting suck trying to create a =COUNTIF formula from a sheet that has my date column, and several other qualifying status columns.Any advise would be greatly appreciated. Here is where I am at so far and I am getting an #INVALID Dat…Formulas and Functions503Elvin Montanez

Lisa Devolder Babula 87 views 2 comments 0 points Most recent by Lisa Devolder Babula Formulas and FunctionsFirst post 04/30/18,Last post 05/02/18I am looking for guidance as I feel like I am missing something really simple. I would like to be able to have a title(label) included in my COUNTIF statement. This is the total count formula I have for the parent row: ="May 201…Formulas and Functions872Lisa Devolder Babula

First post 04/27/18,Last post 04/27/18I am struggling with another Countif formula. I have a working formula in one column that counts proposals filtered by month and year. I am trying to modify it to add another criteria so I can count proposals filtered by the month year t…Formulas and Functions601Kelly Ospina

First post 04/27/18,Last post 04/27/18I'm using the Sum =SUM(CHILDREN()) to capture scoring of items by various teams, which is working great for each tool/category, but I want to now show a score by team (not just overall total by tool). =SUMIF(Tool6:Tool187, "Developm…Formulas and Functions33322tere.pile42541

First post 04/27/18,Last post 04/27/18I have a sheet with different values I would like to sum a group of them and not in detail. Example I have values like CAR, BUS, TABLE, CHAIR I am trying to use a countif formula to sum up a total off all vehicles, like CAR and BUS. So…Formulas and Functions231Eriq

First post 04/26/18,Last post 04/26/18I'm trying to convert an excel spreadsheet to a smartsheet. How would I convert this formula? =IF(SUM(AH6:AL6)=0,,AJ6+$AP6+$AS6+$AT6) Yeah, I am an extreme rookie when it comes to this stuff.Formulas and Functions32leahr46246

First post 04/26/18,Last post 04/26/18I am trying to correct the SYNTAX for the below scenario as I repeatedly get #INCORRECT ARGUEMENT SET as a result on line 3. In the column labeled "Today" I have the following formulas: LINE 1 =IF(MONTH(TODAY()) = [DOJ Anniver…Formulas and Functions11William Lafferty

First post 04/26/18,Last post 04/06/20I am trying to capture the total number of active projects found in a specific Workspace. Each project is its own, separate, SmartSheet. The way I am able to do this now is by manually creating a Formula (COUNTIF({Proj Name Range 1}, "…Formulas and Functions202214Bryan Sampson

First post 04/26/18,Last post 04/26/18I want to concatenate two functions in a single cell and populate the values in the same cell separated by coma.In excel we do the same by =H65K65 &","& I65L65 but in smartsheet when I try the same like =[Next month Pro…Formulas and Functions271Soumya

First post 04/26/18,Last post 04/30/18I am struggling with creation of formula for defining tasks status (Green, Yellow, Red). Getting the UNPEARSEABLE or INCORRECT ARRANGMENT SET error messages. My formula is right now as follows: =IF(ISBLANK([RESPONSE DATE]88); "Gray&…Formulas and Functions113w.bawaked46111

ronnie.johnson46086 2 views 3 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 04/25/18,Last post 04/26/18Not easy to relay what i'm trying to do here... I'm trying to establish a resource requirement list. We have 13 resources available for 4 categories. Right now, I have each category set to cap at 13 resources based on volume per …Formulas and Functions23ronnie.johnson46086

First post 04/25/18,Last post 05/08/18Hi, Please need your help on the below formula. As you can see on the image below, the stage column is set up as a dropdown list. I wanted to get a formula that says, if the project owner decided to close the project at a certain stage (…Formulas and Functions8410Grace

First post 04/25/18,Last post 04/26/18Hi again, Please need your help to correct my formula below. I wanted to count the number of projects that are due to start 14 days based on planned start dates but I am getting "Incorrect Argument Set" error. Please don't get …Formulas and Functions22Grace

First post 04/25/18,Last post 04/25/18For each of our sheets, we use a "Health Status" of Red, Yellow, Green to indicate how that task is going. I would like to create a report which looks across all sheets and simply counts up the total number of tasks which are Red…Formulas and Functions5632Ramsay Zaki

First post 04/25/18,Last post 04/25/18I am trying to create a formula to check a box in one column if a date in another column is greater than a specific date. Here is what I have, that is not working: =IF(ISDATE([Estimated Close Date]1), IF(AND([Estimated Close Date]1 = &…Formulas and Functions164Kelly Ospina

First post 04/25/18,Last post 03/19/20Hello community :) Is it not possible for % Complete to default/autofill to 0% when inserting a new row? When I insert a new row (between 2 other rows) and enter text in the Primary Column, everything from the previous row gets autofill…Formulas and Functions502Emma S

First post 04/25/18,Last post 04/25/18I have a primary field that contains date information and I need to convert it to a date, so that I can compare it against another date field. The format of the text date is 20180418, and I need to convert it to a date, and cannot …Formulas and Functions2732Daniel Wiant

First post 04/25/18,Last post 04/25/18Help! I hit the 25000 cell limit when doing formulas .is there a work around or a way to get limit lifted with business license?Formulas and Functions702tcanelli41471

First post 04/24/18,Last post 04/25/18I'm sorry if the answer to my question is available. I could not find information about automating a scheduled update criterion included in a formula. For a monthly dashboard, I created a series of formulas to count the number of topi…Formulas and Functions262Ginger Mason

First post 04/24/18,Last post 04/24/18Hello, I'm trying to configure a column to reflect the Target % Completion based on days from Finish date but am hitting a snag for Finish Dates that have passed (resulting in a percentage higher than 100) or Start Dates that haven't arr…Formulas and Functions181JenValdez

First post 04/24/18,Last post 05/02/18I am trying to create a line chart widget. The chart would display the date an incident or incidents were reported on the X axis. The y axis would display the number of incidents scale. The widget would report the incidents per the last 90…Formulas and Functions22aalbert44

First post 04/24/18,Last post 04/25/18I run constantly to the same problem and decided to shout out for help. Basically my problem can be defined as cross sheets conditional autofill. My case: Sheet 1 (offers)  sales people add data about new offers with the web form (that's…Formulas and Functions1021Andro

Christian Contzen 23 views 1 comment 0 points Most recent by Shaine Greenwood Formulas and FunctionsFirst post 04/24/18,Last post 04/25/18Dear Smart Sheet Users, as a newbie, I'm not familiar handling depending possible values in Smartsheet. We want to approve a deployment process. If a user chooses value 1 in column A during data entry then there should only be a …Formulas and Functions231Christian Contzen

First post 04/23/18,Last post 08/09/18Hello All, I hope you are all doing well. I'm trying to use the Countifs formula by referencing our Portfolio Project sheet. I'm using five columns. One column is the project status which I am limiting to those projects with a status of …Formulas and Functions21974thadr

First post 04/23/18,Last post 04/23/18I am looking for some help on this one. I need to be able to find duplicates but only under specific conditions. For example, I have a list of SKUs as one column, and a second of the order status of that item. I need to know when multiple…Formulas and Functions894Brett Mathison

First post 04/23/18,Last post 04/24/18Hello, I am trying to sum hours noted in the children of a row (Total Hours per Project) if the current month is noted in another cell (Week Ending With). Here is what I have: =SUMIFS(CHILDREN([Total Hours per Project]1, [Week Ending W…Formulas and Functions1042Ally

First post 04/23/18,Last post 08/01/18I am using one of the PM templates while adding in additional columns for actual start dates and actual finish dates. As such, somewhere I have lost the duration formula in that column. Can someone please help me with the formula that wo…Formulas and Functions11444jeckenrode42196

First post 04/23/18,Last post 04/24/18Hi all, I am building a project tracker however I am new to creating formulas so please need your help again. Based on the image below, I wanted to get the Stage and the Progress of the project that will later complete my summary report …Formulas and Functions33Grace

First post 04/22/18,Last post 05/22/20Hi All, I have a sheet of drivers list. And in another sheet, I want to create a column which get driver name from drivers sheet. Can I do it in smartsheet? ThanksFormulas and Functions56711Jonathan Vo

First post 04/22/18,Last post 04/22/18Hi all, Please need help on formula. The example image below is a project with sub tasks and I wanted to create a formula in the Progress column highlighted in yellow (this is the main header). The condition is: if the status of the row …Formulas and Functions122Grace