-
Duration Formula Help
Hello, I am trying to create two duration formulas. One is the duration is between request date and manager approval date and the other is the duration between manager approval date to admin approval date. All three of the date columns are the date column type. The date columns are filled in automatically by Workflows. I…
-
IF with OR
I want to add to my formula for Past Due tasks: =COUNTIFS([% Complete]:[% Complete], <1, Status:Status, <="Complete", Health:Health, <>"", Finish:Finish, <TODAY()) Status can be "Complete" or "Pending" How do I revise my formula? Thank you.
-
Need help creating formula! =SUM(CHILDREN([Time off Personal]@row<'x'))
Trying to create a formula that counts number of days off in children under parent row. Any advice???
-
COUNTIF blank (Date column)
I'm trying to count rows that do not have a date value added in a date column. The right answer is 5, but when I use the following formula, I'm getting 177: =COUNTIF({Approval Date},"") I've also tried the following with the same results: =COUNTIF({Approval Date},ISBLANK(@cell)) Any clues?
-
Index Collect/match formulas / automatically update
Hi everyone, I'd like to have a formulas which reports what we call "Cost Center" from one/multiple sheet into a Year Planning sheet. I need the formula to give me the "Cost Center" if a cell is matching the name of the collapse one (category) above it. Source sheet (Master Sheet NL) : Year Planning sheet : My formula :…
-
Contains function
I am having trouble with a formula that contains multiple "If(contains)" function. The following returns unparsable. =IF(CONTAINS("52", [Account #]@row), "52", IF(CONTAINS("53", [Account #]@row), "53", IF(CONTAINS(“54”, [Account #]@row)”54”, "")))
-
Percentage formula based on a checkbox.
Any suggestions on how to make this exceptions formula more accurate? Smartsheets keeps adding 10 rows to my sheet with no data causing my formula to be off. I have 88 rows with data and a total of 98 rows. Out of the 88 row 21 are an exception with the checkbox selected. This is the formula I am using. =COUNTIF({Master…
-
Formula Question
I have a list of items for sale in (column A) in a dropdown list to be used in a webform.... IE: Dress $25 Pants $50 Shirt $30 I want to have the total cost of the selected item (single select in the column) populated (dollar amount only) in Column B automatically. If Item 1 (Dress $25) is selected in Column A THEN "$25"…
-
Nesting If Statements - Looking for Results Across Two Sheets to Pull into a Third
I am working with three sheets for this project: Sheet 1 - Open Projects, Sheet 2 - Finished Projects, Sheet 3 - All Info. When a project moves from "Open" to "Finished", it is moved automatically from sheet 1 to 2 (these are raw data sheets that cannot be changed or combined). I need to pull down the status into Sheet 3…
-
CountIF one item is a part of multiple selections
Greetings- Im trying to do metrics and a graph for individual items that may be selected as part of multiple items in 2023. For example, my form has the option to select one or multiple from the list: Kids (5-12) Teens (13-17) Adults (18-64) Seniors (65+) Families General Public Staff Use So a user could select Kids and…
