Formulas
Discussion List
-
Help with Trend DataIn Formulas and FunctionsI need some help with collecting data for trending. Currently, I have multiple projects with all of their top line data dynamically linked to a Roll-up Sheet. On this roll-up sheet I have data that is calculated from the project Status. …
-
FormulaIn Formulas and FunctionsI want to include a column, On Hold, a checkbox (0,1). If it's checked, I want the State to be "On Hold", with another formula that enters State depending on two other cells - Status (RYGB) and % Column. Unchecked and it shoul…Answered - Pending Review 10 views 1 comment 0 points Most recent by Mark Cronk Formulas and Functions
-
IF(CHILDREN()) ? - Child inherits parent traits for entire columnIn Formulas and FunctionsI could've sworn I'd seen this but now I can't find it: We have a sheet for incoming project requests. Our general population can request multiple new mkt materials (printed direct mail, email, outlook MSG, etc.) for a campaign in a single…Answered - Pending Review 31 views 4 comments 0 points Most recent by Laura K Formulas and Functions
-
Update Sheet 1, Based on Submission to Sheet 2In Formulas and FunctionsI have a quick question. I have 2 sheets (Sheet 1 and Sheet 2). In Sheet 2, users submit a form and a field (which is hidden) is automatically checked indicating it's been submitted. What I'm wanting to do is - essentially - notify Sheet 1…Answered - Pending Review 15 views 4 comments 0 points Most recent by Mike Rini Formulas and Functions
-
CountIf with Date rangeIn Formulas and FunctionsI am trying to count the number of requests types between a date range. This is what I thought would work: =COUNTIF(({Request Tracker Range 4 - Request Type}, Category5), AND({Request Tracker Range 3 - Date Requested}, DATE(2019, 01, 0…
-
FormulaIn Formulas and FunctionsHaving difficulty with a formula setting task state (Not Started, In Progress, Complete, On Hold) depending upon how the columns on either side are set - Status/RYGB and % Complete. =IF(AND([email protected]=“B”, [% Complete]@row =1),"Compl…
-
Is there a way to COUNTIF checked boxes, but have the formula skip over boxes with an error?In Formulas and FunctionsI have successfully implemented a formula in a sheet summary that COUNTIFS checked boxes in a column but because of the nature in which this sheet is being used, some of the checkboxes that I am counting have temporary #NO MATCH errors due…
-
NETWORKDAYS Concern With Future and Past DatesIn Formulas and FunctionsWorking on creating schedule variance icons, I am running across an issue which might be solved with absolute values of NETWORKDAYS but wanted to understand how to better structure the formula correctly. In this example I have two helper c…Question 13 views 0 comments 0 points Started by Taylor Compton - NOAA Federal Formulas and Functions
-
Vlookup functions not working on a Master SpreadsheetIn Using SmartsheetMy colleague and I, who do extensive work on a master spreadsheet that pulls data from many different sheets, are having a lot of trouble with the vlookup function on this particular sheet. We use the vlookup function in multiple different…
-
Weeks to Date Formula- Revision NeededIn Formulas and FunctionsHi All, I am currently using the following formula to calculate the weeks until my project delivery date. =INT(([Due Date]@row - TODAY()) /7)) We deliver the project on Tuesday and count that week as week 0. How can I modify this formula…