-
Count if there is a blank in another column
I am looking for a formula that will count how many times Alex's name shows up in the "assigned to" column but only if the "complete date" column is empty. Is this possible? Thank you!
-
Not sure how to write formula correctly, not even sure this is a SUMIFS
Hello, Apologies for yet another basic question, but I'm having troubles wrapping my head around how to get a formula to behave a certain way. I'm still working on a PTO manager tool (requests PTO, automated approvals, and auto calculations on PTO Balance, etc...). I have 3 total grids (Submission grid, Track grid, and…
-
Lookup/CountIF Formulas for Multi-Select ranges
Hello, We are referencing another sheet and are wanting to know how many times the word "SNAP" appears in the multi-select cells within a row. Right now, this is what we have, but it won't work. We have tried multiple different formulas as well and cannot seem to find anything to count the number of time "SNAP" shows up in…
-
Days Remaining from a Date
Hello! I'm trying to calculate how many days until the Start Date. I used the following formula: =[Start Date]6 - TODAY() What am I missing? The date column is a date type and the formula column is text/number. Thanks!
-
Divide by Zero Message and IFERROR formula
I am getting a Divide by Zero Message when putting in this formula. It is correct because there are no items that fit this criteria to average. =AVG(COLLECT({Credit Granting Article Tracker Compliance}, {Credit Granting Article Tracker Month Completed}, "2", {Credit Granting Article Tracker Major?}, "No")) I attempted to…
-
import and working with an extensive audit questionnaire in Smartsheet
Hi together, we want to import an extensive questionnaire based on an excel sheet and set the questions to At the moment it looks like the attached example 😃: question 1 / note / percentage / notes question 2 question 3 if we use the form in Smartsheet it will only show the headings, not the questions how can we rotate the…
-
Variance Between 2 Dates (Weekdays Only)
Does anyone have a variance Formula between 2 dates that only counts the weekdays and not the weekends? Here is my Current Formula which Counts All 7 Days: =IF(ISBLANK([Finish Date (Actual)]@row), "", IF(AND(ISBLANK([Finish Date (Planned)]@row), ISDATE([Finish Date (Actual)]@row)), "Start Date Missing", IF([Finish Date…
-
Counting a Specific Word in a Multi-Select Column
Hello! I am trying to count a center word in a column that has multi-select and it is just not working. This is what I have now: =COUNTIFS({Lakeside Village Opening - Action Items Range 1}, [Primary Column]@row, {Coronavirus Unified Working Group - Action Range 1}, $[Column4]$7) The [Primary Column]@row is the word that is…
-
MULTIPLE AND ON MULTIPLE COLUMNS wANCESTORS
Hi there... really need help 😯 I have a list of actions, all actions are either a PARENT action (Outdented) or child actions (Indented). I added a column with =COUNT(ANCESTORS()) to have 1,0 depending on the case. I have another column with a "Due date", and another with "Completion Due Date" where I want to monitor PARENT…
-
SUM of Check Box IF Function that returns a value.
I've created several "IF" formulas on a sheet. An example of one is as follows: =IF([Kickplate Installation]1, "$42.86", ""). When the checkbox is checked, it does return my value of $42.86. However, I've also created a column to total all of the values returned. When I "Sum" the returned values from the formula, the "SUM"…
