-
COUNTIF referencing another sheet
I am needing to count the number of rows that are classified as rolling deadlines. The data I am trying to reference is in a separate sheet. This is the formula I currently have that is giving me the #UNPARSEABLE error. =COUNTIF({Proposal Tracker Range 1}[Deadline Type]:[Deadline Type], "Rolling Deadline") Please help me…
-
Fprmula to count date with 2023 as year
Hi im trying to add the week number only for projects with 2023 dates. the below only counts all week number but doesn’t distinguish between year. can you help =WEEKNUMBER([ACTUAL - Site Acceptance Completion Date]1)
-
Show Last Non-Blank Text Cell in Row
Hi Everyone, Hoping you can help because I'm stumped. In the 'Most Recent/Current Project' column pictured below I am trying to add a formula that will show the text within right most cell that is not blank. I've tried two methods that work in Excel, but the formulas don't seem to be usable in SmartSheet. In Excel, I've…
-
COUNTIF not returning correct amount of rows
hi i have a formula in my sheet summary that uses a countif formula to to count how many rows contain "Eng Ops" in my "Function" column. the formula puts out 31 as the answer but when i filter the sheet to show rows containing "Eng Ops" they're 35 rows. =COUNTIFS(Function:Function, CONTAINS("Eng Ops", @cell))
-
How do I count if someone attended?
Hey! I've been messing with this formula for a bit, and I'm kinda stumped. I'm trying to count how many people have attended a course on a certain day. So, if "Attended" is checked on 1/23, then that should count as one person attending. Columns Referenced: Attended = Check Date = Date format…
-
Best method for saving updates across 2 sheets
Hi, I hope all reading are well! I have a question relating to the best way of obtaining updates across 2 smarsheets. Sheet 1 contains multiple columns of data, which are imported on a weekly basis from a 3rd party app. Each week the data from the previous data is overwritten with the new data. In Sheet 2 I would like to…
-
Update a cell on a master list from individual identical laid out sheets
I have a template that I use to create data sheets for unique projects. All rows and columns are the same for each project. I also have a master sheet that lists all the projects which are populated with information from the same cell location from each project sheet. I have been able to go from the master sheet to the…
-
Automate symbols
This should be easy but I am stuck trying to figure out how to get the symbols to work in a formula to reflect health of budget percentages. All the single lines work except the green one - it just shows up blank, with no error (the highlighted drop-down has the green formula only like below) I have tried the combo forumla…
-
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…