-
COUNTIF CHECKBOXES FROM MULTIPLE SHEETS
I NEED A COUNTIF FORMULA FOR CHECK BOXES IN MULTIPLE SHEETS =COUNTIF([Priority Vendor]:[Priority Vendor], 1) +COUNTIF([Priority Vendor]:[Priority Vendor], 1) SHEET A SHEET B
-
Formula to List all Sub-Task Owners in One Cell
I am hoping to have a column/cell that indicates all team members that contribute to a given project (ideally in a contact list column type). Is there a formula that could reference only the child rows and compile certain child row cell values into a comprehensive list? For example: For Project A (shown below), Bob is the…
-
COUNTIFS to pull data from multiple columns
Hi everyone, I'm running into an issue trying to count the number of times a word appears in a 10 column range (SCPD Log Range 9) in a one month period. I have a column that assigns the month its respective numerical value and the same for the year. I'd expect this formula to look across all 10 columns and count how many…
-
SUMIFS returns no total with one line of data
We are using this SUMIFS and COUNTIFS as part of our caluclations for critical path. They have been working fine for the entire team, except one member who only had 1 project meeting the criteria. Is that why all the forumulas are returning a zero for her? Is there a way to tweak this so any number listed is returned? The…
-
EDATE Function like Excel
Hi! Date math in Smartsheet requires fairly complex formulas for anything besides adding days. Can we add something like EDATE from Excel? This allows you to add a start date and a number of months to generate a new date.
-
Count cells containing text only, excluding text with digits
Hi, I need help with a function/formula: I am looking at counting the number of crew (they are listed by first name) and at the same time exclude any cells with text & digits (names with quantity). I hope this makes sense - I did some search and cannot find any formula that does the job. Many thanks, Thanks, Salèha
-
Move row workflow not running
hello i have run into a problem where i have a workflow setup that automatically moves a row to another "Active" sheet when the decision column is set to active, and it works fine when i do it manually but i tried to add a vlookup formula to pull from another sheet that is filled from a form since you cant use forms to…
-
Cell Linking? Index/Match?
I have 83 project schedules in a folder. I have a 'Key Milstone' Tracker with project locations in the primary column and all the milestones I need to grab as columns. Each milestone I need is in the exact same place on each of the 83 sheets. Is there an easier way of linking the cells other than sheet by sheet; or some…
-
RYG Formula for Multiple Criteria
I'm out of practice with formulas. Any advice/direction would be appreciated. Thanks! Requirements: If status = Complete or N/A, then "Green" If status <> Complete or N/A, and finish date is past due, then "Red" If status <> Complete or N/A, and finish date is approaching within 5 days, then "Yellow"
-
Countifs with Multiple Criteria
Hi - I need assistance with building a =COUNTIFS formula with multiple criteria. Here is my current equation (that I am getting a '0' on) Current Equation: =COUNTIFS({B23 Delegation Registration Status Region}, "SOAF", {B23 Delegation Registration Status Registration G}, "Athlete" + "Unified Partner" + "Medical Staff" +…
