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 …
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 Co…
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…
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 she…
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 …
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 fr…
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 w…
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 sh…
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
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 row…
