-
How to count the number of Flagged rows
Hi, I'm trying to count the number of rows on my sheet summary that are flagged on my sheet it seems my formula is not working it gives #INVALID DATA TYPE error Below is the formula : =COUNTIF(TBD:TBD, @cell) The name of the column is TBD as seen on the screenshot below :
-
How can I count a range of dates based of a condition?
I'm trying to keep a tally of how many cancelled dates per month for each state/country and I can't quite figure out the formula to make it work. Can someone please help me?
-
Seeking a formula that counts specific characters in a cell.
My project task sheet has parent rows for each department and child row for each project within the parent department. Each project row has a LEAD DEPT column with dropdown options that show the department acronym and business unit---DEPARTMENT (Unit). The LEAD DEPT options are; DCM (Marketing) DCM (Membership) DCM…
-
Weekly Comparison
Hello guys, I am trying to add a column that will provide me a %complete for previous week. I have this week's percentage and a PM is updating that weekly however I was wondering if there is a way to have another column that would be updated with previous week's percentage without the manual labor (think of 300+ rows). Is…
-
Can somebody help trying to read only data from this Month
Hi My plan is to bring data from the current month, from a different sheet using cross sheets formulas. My code below is not working any idea why? It says #UNPARSEABLE Any help is much appreciated =SUMIF({Actual Completion Date}@row)=MONTH(TODAY()),({Completed Jobs Value})
-
Auto Label Parent Rows
Hello! I'm looking for ways to automate labeling the parent rows for an onboarding sheet. I want to automate the label of the day so that I won't have to manually adjust it every time. Here's a sample a screenshot:
-
How can i use symbols of 4 different colors for the following scenarios?
could you help me please? There are 2 parts; part 1; contract notice period, part 2; contract expiry time for part1; If the day remaining until the notice of termination is over 60 days; Green If it is between 60 - 15 days; blue If between 15 and the termination notice period; Yellow If the notice period for termination…
-
VLOOKUP/JOIN/COLLECT - Need help combining groups of emails
Good afternoon, I am stumped & hoping someone can help. In short, I have a Reference Sheet with the contact info and a Communication Plan Sheet. In the Reference Sheet, I added an Address/Filter/Email List column. The Email List is grouping all of the addresses based on which group they are in, so when you copy the Email…
-
Require Help with COUNTIF Formula on Smartsheets
Hello everyone! I am trying to count the number of records for the current year(2021) from 'System Generated' date column -(Request Date )with formula - =COUNTIF(Request date: Request date, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())) in the 'Sheet Summary' section. This is not working - says #UNPARSEABLE Alternatively I have…
-
Countif the Year 2021 on a Column Returns #invalid data type or zero.
https://app.smartsheet.com/sheets/xXvWq9JrWMjRXGHv7jcV4Q4GF45wJWc4C32GcHw1