Formulas and Functions
Archives for October 2020
Discussion List
-
Nesting a formula in an 'if' statement - conditional valuesIn Formulas and FunctionsI have two reimbursement schemes for staff vs. managers for an expense, and am using a 'checkbox' to identify managers when submitting a claim. Managers will have a 'checked' checkbox in that column. I'm trying to use in a IF statement to…Answered - Pending Review 13 views 1 comment 0 points Most recent by Purnima Gore Formulas and Functions
-
If text formula - if one cell = a name then another cell = an email address. See example belowIn Formulas and FunctionsI want to create a formula that looks at the Designer cells text and if that cell equals a certain designers name the Designer Email cell equals their email address I am a novice, as you can tell, and would appreciate help :) Thank you
-
Multiple IF/AND/OR/ FunctionsIn Formulas and FunctionsHi! I thought I had figured this out... but midway through making changes, realized that it's still not working quite as effectively has I thought. I'm currently using the below formula to change the Offer Phase parent row from "In Pr…
-
Match any part of multi select to another multi select on another sheetIn Formulas and FunctionsHello, I have two separate sheets that each have multi select columns and I want to join a particular column if it has ANY mutual matches between the two. For example, on sheet 1, A B C are selected in the multi select and I want to find a…
-
Multiple IF/And statements in one columnIn Formulas and FunctionsI am using the function: =IF(AND([email protected] = "Low", [Angela Approval]@row = "Approved", [Billye Approval]@row = "Approved", [Jason Approval]@row = "Approved", [Michael Approval]@row = "Approve…
-
how do I display the highest condition from the child cells in the parent cell?In Formulas and Functionsfor parent I the cell (1, 3) must show "Urgent) and for Parent 2 the cell (1,9) must show "Action"Answered - Pending Review 12 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
I need to calculate the networkdays between 2 fields including when the end date is blank.In Formulas and FunctionsColumn 1 titled "todays date" - this is the date the item is submitted Column 2 titled "manager response date"- this is the date in which a response was provided Column 2 may be blank. - Therefore in this case I need…Answered - Pending Review 127 views 5 comments 0 points Most recent by Kelly Moore Formulas and Functions
-
=NETDAYS FORMULAIn Formulas and FunctionsHi, I am trying to calculate how many days it has been since a unit was paid for however I am getting the #INVALID DATA TYPE error. I am assuming the issue is that one of the dates I am referencing is pulling the date from a different she…Answered - Pending Review 87 views 3 comments 0 points Most recent by David Joyeuse Formulas and Functions
-
Ignoring DuplicatesIn Formulas and FunctionsHi I added this data mesh to add inspection number based on date of inspection. Now we are getting two inspection for same building(in two different months) , but formula still using the initial month to formulate the Inspection number. is…Answered - Pending Review 13 views 1 comment 0 points Most recent by Genevieve P. Formulas and Functions
-
Can you use CountIF if there is more than one term in a cell?In Formulas and FunctionsI have a sheet that is updated from an export from another system. One of the fields in the other system is for category and can have more than one category selected. So when the data exports it appears in Smartsheet as "Category 1,…Answered - Pending Review 5 views 1 comment 0 points Most recent by Kelly Drake Formulas and Functions