Formulas
Discussion List
-
Help with this IF this then this formulaIn Formulas and FunctionsPlease help me figure out what I am doing wrong with this formula: =IF((([Size of Install]@row = "Small - Single Server, no HA, no NLB, HPAC PP+IA+, no HPAC Scan, no HPAC mobile connector, includes PPM/PDM, WJA, UPD, 500 printers or…
-
Multiple Results FormulaIn Formulas and FunctionsHello! everyone I was wondering if someone could help me with a formula We have an audit schedule based on 5 years and I currently have the "Count" essentially telling me how many times a topic was audited in the past 5 years. Wh…
-
Calculate Week number from multiple choice dates columnIn Formulas and FunctionsHi, We are running a Wellness challenge for a charity. Participants log the days and duration when they performed the activity. We allow selecting multiple dates for the same activity. I try to total Duration for a week. "Duration&q…
-
Year( formula issueIn Formulas and FunctionsCan any one help me why this formula doesn't work. It results in #invalid operation =IF(YEAR([Project Works Commence]@row = 2022), WEEKNUMBER([Project Works Commence]@row), " ")Answered - Pending Review 10 views 1 comment 0 points Most recent by AnthroTim Formulas and Functions
-
Formula to automatically link Week to DateIn Formulas and FunctionsHello, we have individual production schedule sheets where we assign hours against weeks. We want to create a column that will autofill with the Date it is starting based on the first Week Number column that has hours in it (example attach…Answered - Pending Review 18 views 4 comments 0 points Most recent by Emmet McKenna Formulas and Functions
-
Is there a way to add data to one sheet and have it automatically pull to another sheet?In Using SmartsheetI have two sheets, and they share a similar column, but only that one column is consistent between the 2 sheets. The column is called "record ID#". I am hoping there is a way that once I add a new record ID # to one sheet (Sheet …
-
IF Formula with ChildrenIn Formulas and FunctionsHello Everyone, I am trying to figure out a formula that would show the children's status on the parent row. IF the children's "Status" column is "Completed" OR "Completed By Black Ops", the parent "Case …
-
COUNTIFS with OR and ISBLANK to find number of blank cells 7 days agoIn Using SmartsheetHi, I have a formula that is working to count the number of active employees in Role 1, Role 2, Role 3, and Role 4 who did not qualify because the date field is blank. =COUNTIFS({ROLLUP-EmpStatus}, "Active", {ROLLUP-Role}, OR(@c…Answered - Pending Review 17 views 8 comments 0 points Most recent by Lori Flanigan Using Smartsheet
-
How to populate a column in a sheet based on a column from another?In Formulas and FunctionsBeginner here. I want to populate a column with the names of people in a new sheet, with the data to be taken from a column in an existing sheet. In this sheet, the names are given in the column multiple times over since it reflects each o…Answered - Pending Review 22 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
If Match Check BoxIn Formulas and FunctionsHow do I write a formula to check a box next to an ID Number if that same ID Number is also present in another column? So Column 1 is ID Number to complete and Column 2 is ID Number completed list. Thanks in advance!