Formulas and Functions
Archives for February 2018
Discussion List
-
First post 02/28/18,Last post 03/01/18I used this formula to set the range, the criteria and then the sum range but it is returning zero. The range is a different column than the sum range. Any advice? =SUMIF({SSS Range 3}, >"12/31/2017", {SSS Range 3})Formulas and Functions6313Tom Holder -
First post 02/28/18,Last post 08/07/18Good afternoon. I have created a sheet with a form to capture reservation details for a live performance. There are 4 performance date options and form users identify their 1st-4th choices. Once received, they are assigned a date and the …Formulas and Functions5623kym4639
-
Venelina Rusinova 40 views 1 comment 0 points Most recent by Shaine Greenwood Formulas and FunctionsFirst post 02/28/18,Last post 03/01/18Hello, I am experiencing the following issue: In a sheet I maintain my project data is, a single identifier for a completed activity is an entered date. If date is lacking in the respective column, other value options are either a …Formulas and Functions401Venelina Rusinova
-
First post 02/27/18,Last post 03/01/18I need to include a column that shows me the number of days that a person maintains each state (not including weekends), if you don't enter the form every day to update the information. Could someone help me with this? date of creation| N…Formulas and Functions321Carla_Ahzul
-
First post 02/27/18,Last post 02/27/18Someone knows how to include weekends in a single row on one sheet and that all other rows include only work days? Thanks!Formulas and Functions171Carla_Ahzul
-
First post 02/27/18,Last post 02/27/18Hello How do i get this formula to Calculating the numbers of Days when i select the date columns. e.g I want to select the dates and then it calculates the number of days from the two date ranges selected. (Image)Formulas and Functions7211Jacob Judd
-
Mollie.cleanvibes 16 views 1 comment 0 points Most recent by Shaine Greenwood Formulas and FunctionsFirst post 02/27/18,Last post 02/28/18Building an employee hiring database (sheet 2) off our hired applicants sheet (Sheet 1). After typing an email address in the first column of the sheet 2 , it should populate 4 or 5 subsequent columns across the same row in sheet 2. The co…Formulas and Functions161Mollie.cleanvibes
-
americansurveymanagement35236 16 views 5 comments 0 points Most recent by americansurveymanagement35236 Formulas and FunctionsFirst post 02/27/18,Last post 02/27/18Based on the below screenshots, I am looking for a formula to SUM the FEE column only if the Project Stage column is equal to "Paid". I feel I am close to solving the formula. Any suggestions will be greatly appreciated. (Image)Formulas and Functions165americansurveymanagement35236 -
First post 02/26/18,Last post 02/26/18Hello, As an example, In a cell, I am looking to count the total amount of "Completed" statuses that are in a specific column labeled "status" on one or more sheets and have it tied to a specific "Category" c…Formulas and Functions231michael.dilios15206
-
[email protected] 16 views 2 comments 0 points Most recent by [email protected] Formulas and FunctionsFirst post 02/26/18,Last post 03/04/18I am looking to add date columns that are based on a criteria in another cell. I can use the COUNTIF statement to add the dates but when I place an criteria in place I get an error. =COUNTIF([Due Date]:[Due Date], <=TODAY()) This w…Formulas and Functions162[email protected]
-
First post 02/26/18,Last post 02/26/18Hello :) I need some help :) i think i have a few steps i will need to complete .. however big idea is to be able to make sure multiple columns have criteria matched; then send a notification with an attachment as well as mark a checkbox…Formulas and Functions251dana y
-
First post 02/25/18,Last post 02/27/18Hi all, Longtime reader, first-time poster...having a struggle day with the brain and some trouble with a nested if shooting back the INCORRECT ARGUMENT error. Trying to code a 5-Part Progress Bar column with ranges based on a Status % c…Formulas and Functions852WBS PM
-
First post 02/25/18,Last post 02/26/18I apologize if this has been asked. I am trying to figure out a Countif formula combined 2 columns. Column 1 is a hierarchy level column in 5 levels (0=great-grandparent, 1=grandparent, 2=grandparent, 3=child, 4=child). Column 2 is a int…Formulas and Functions1234kdf3
-
First post 02/25/18,Last post 02/26/18Hi, I am using an "Issued" date column as a trigger to send approval requests. I am trying to capture the number of days since the request was issued in the "Age" column, where I have this formula: =NETWORKDAYS(Today(…Formulas and Functions275aaboueid
-
First post 02/23/18,Last post 02/26/18Do you have any training material you can share on “best practices” for building a project plan/timeline to populate Dashboards correctly (e.g. metrics and tables). Examples of things I want to do: Present the overall project health as re…Formulas and Functions1052Amanda Crawford
-
First post 02/23/18,Last post 02/25/18Hi, New to Smartsheet, and wondering if there is a way to have the % complete cell calculated by the number of 'child' tasks only, rather than basing it on the amount of time each task takes to complete. For example, if I had 5 'ch…Formulas and Functions162Stephen Walker
-
First post 02/23/18,Last post 02/23/18Is there a way to do this? I would like my Primary Column (Task Name) to combine it's text with my 'assigned to' column if the condition of the checkbox in column 'Show' is checked. thanks MikeFormulas and Functions172IFCC
-
First post 02/23/18,Last post 02/23/18Hi Everyone! I am attempting to reference two different cell ranges from another sheet into one status sheet. However, when I create/update one sheet/cell range the other sheet/cell references change to the new one. Can you have more th…Formulas and Functions152mmurphy14986 -
First post 02/22/18,Last post 03/08/20Hi! I need to know how I can make a report with last entry to each "assigned to" with the row that generated into the Form. Anybody know how do it?Formulas and Functions2753Carla_Ahzul
-
First post 02/22/18,Last post 02/26/18Is there a way to hide cross sheet formula links? If you define a reference range on a sheet for vlookups I would rather not see all my columns on the parent sheet filled with little mouseover links. ThanksFormulas and Functions981Thane Knutson
-
First post 02/22/18,Last post 03/01/18Within a sheet (call it "A") I used a formula referencing a different sheet (let's call it X). Later I deleted sheet "A". However I see an annoying "Used in formula from unknown sheet" in sheet X. Is there an…Formulas and Functions3032deepak_ar
-
First post 02/22/18,Last post 02/22/18Hi, guys! I am trying to create a function which will tell me the next date where a certain condition is met. I have a column called "Due" with due dates for a report and a column called "Received" with a checkbox. I w…Formulas and Functions1922mmiddleton
-
First post 02/21/18,Last post 02/21/18I want to be able to average, or other function, over a subset of the cells in a row. The number of cells I want to include is specifiied in a separate cell. In Excel, I accomplished this with OFFSET. I read another article here noti…Formulas and Functions401Chris Ross
-
First post 02/21/18,Last post 02/28/18Hi I have a project risk and issues Log and want to pull through the top 5 risk and issues through to another sheet (based on risk score). The risk and issue Log have a text description (there is a risk that....) and a risk score (5). …Formulas and Functions1074Phil Smith
-
First post 02/21/18,Last post 02/22/18Good day All: I am trying to use a SUMIF formula that would allow me to add everything less than 2,000 with multiple status. Here is the formula I am using but I am receiving an invalid operation. what am I missing? =SUMIFS({A3: Fi TL…Formulas and Functions815Kal-El
-
First post 02/21/18,Last post 02/26/19I have a formula (see below) where I'm trying to get a count where multiple criteria apply. The first date range renders a correct count but fails once the second one is added. I've tried multiple iterations of the formula, this is my cu…Formulas and Functions2586bsemingson30431
-
Mikael Gustafsson 16 views 2 comments 0 points Most recent by J. Craig Williams Formulas and FunctionsFirst post 02/21/18,Last post 02/21/18Hi, I have a sheet with two date columns. I want to count the rows where only one of the date columns have a value. I´ve tried to create a third column with a formula that sets it to 0 or 1 depending on whether the second date column I…Formulas and Functions162Mikael Gustafsson -
First post 02/20/18,Last post 02/21/18Is it possible to do an Index and Match referencing another sheet? My formula works when I am using data on the same sheet but when I try to reference a different sheet it does not work.Formulas and Functions2023celento
-
First post 02/19/18,Last post 02/19/18I'm trying to set the RYG status of a task based on End Date and % Complete of the task. I've put a formula in place using =IF(AND(... but I keep getting the error "# INCOMPLETE ARGUMENT SET" Below is the formula, can anyone t…Formulas and Functions571mheaps38436 -
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 Functions1071MariaF
