-
COUNTIFS & ISDATE FORMULA
Good Afternoon, Hope you are safe in this winter weather. MY FORMULA is unparseable: =COUNTIFS([DEACTIVATE TIMESTAMP YR 5]:[DEACTIVATE TIMESTAMP YR 5], ISDATE(@cell ), [Abbreviated Org Name.]:[Abbreviated Org Name.], "CHARM")) The formula should count ONLY if any date is appears in column DEACTIVATE TIMESTAMP YR 5 = ANY…
-
Can you make a dropdown option dependent upon another drop down? Parent / child
Hi, I am trying to setup 2 drop downs in a grid sheet. The user will select from the first dropdown (parent) A, B, C and based upon what they select i only want to show the corresponding options in the second dropdown (child). So for A show 1, 2, or 3 For B show 4, 5, or 6 For C show 7, 8, or 9 . Using a form is not an…
-
Dancing With The Stars
Hey family! I have a column with the Stars symbol. I'm using it to rank 1 to 5. While its pretty, I can't seem to quantify them. For example 5 stars = 90%, 4 stars = 70%, etc. this formula doesn't seem to work: =IFERROR(IF(VALUE(Probability@row ) = 5, 0.9, IF(VALUE(Probability@row ) = 4, 0.7, IF(VALUE(Probability@row ) =…
-
How to Phrase a Question for the AI or Write the Formula for Myself for Grouping Data
Hello, I would like to see if anyone can help me parse entries across different columns. What I have in my SS is a list of registration numbers in Column A and departmental associations in Column B. I would like to count how many different registration numbers appear in Column A and then group them by their departments in…
-
Calculating Time in Smartsheet
Hello. In excel, I have a formula that calculates the departure time of a coach from point A by taking the arrival time (a variable I choose) and subtracting the travel time. I then have a formula that subtracts 15 min from the departure time for the load time. The final formula subtracts 15 from the load time for the spot…
-
New Links Disappear! URGENT!
I am creating a new metrics sheet from year prior version (which might be the issue). I an entering new links to 2026 data and the link disappear on refresh. Why and what do I do? I have a Jan 30 deadline
-
COUNTIF & ISDATE FUNCTION
Good Afternoon All, I hope you are stating safe in this winter weather. I have a formula but to no avail I am getting unparseable. I want my COUNTIFS function to count only if there is a date in column (DEACTIVATE TIMESTAMP YR 5) = ANY DATE and count only if the specific criteria from on column (DEACTIVATE TIMESTAMP YR 5)…
-
Return blank when count total is zero
Can you give me a variation of this formula that delivers a blank if total counted is 0? I want to use it in forward months so I don't have to update the metrics sheet monthly, if possible. Thanks, Lisa I tried the IFERROR and IF(COUNTIFS( I could find but most deliver Incorrect Argument. =COUNTIFS({4Q2025 FPG thru Oct…
-
Rolling View - Timebound
Hi community! I'm trying to figure out a way where a report will filter and pull based on a time frame. I have a sheet where all of our cyclical events are listed with start/end dates. I want to provide a way where only current events (in progress today) and going through next 3 months are pulled. Suggestions on how to…
-
Counting Specific Items within an array where row meets criteria
Hello, I am trying to count specific text within and array: Basically, I am trying to count the number of times Testing occurred in the last 2 weeks, so using either a specific date or the check box. I will also expand this to specific people that is not shown in the screen shot. I have the formula to count the array, but…