-
COUNTIF Column Totals - Would like to Exclude Two Cells
We have a form connected to our sheet. Form submissions are added to the top. Each column asks a question where the submitter can choose one of three answers: Yes, No, or Don’t Know The Yes, No, Don’t Know totals are at the bottom of the sheet using the COUNTIF formula. We originally set up the formula to include the rows…
-
Is there an alternative for WORKDAY.INTL in Smartsheets?
Hi, I have a formula on excel that uses WORKDAY.INTL and it doesn't work in Smartsheets. I have made the formula so it only produces dates that are on a Tuesday, Wednesday and a Thursday. Is there another way to do this? Thanks, Liam
-
Need help with an "IF", "CONTAINS" and "OR" formula
Hello everyone First, thanks for your help :) I'm trying to make a formula. I have a cell (cell#1) that has 4 values in it (" one", "two", "three", "four"). I'm looking for a formula that would work like this: If cell #1 contains "one" or "two", then cell #1 =0. Otherwise, calculate the number of values in cell #1. Could…
-
Is it possible to count if a cell changes?
Hello! I am trying to calculate the amount of times a cell dropdown is changed per day. Is this even possible or would it need some magic workaround? In any given day the "current stage" column changes possibly many times. An example question would be: how many times did a cells in "current stage" column change from "Art…
-
Count(Distinct()) function that works with one column (range), but not another.
Hi All! I am using a =Count(Distinct({Range})) which works exactly as expected with one range of data, but returns a "1" with the exact same formula on an adjacent column of data. The only difference between the data in the 2 columns is the data. Same column type, similar numbers, etc. Anyone had this issue before?
-
How do I show health based on end date & % complete?
I'm trying to show health of a project based on how far out from End date + how much of the work has been completed. Green: 100% complete before or on End date Yellow 70-99% and today is < 1 range of End Date <69% and date within 2 days of End Date Red <69% and today is <1 range of End Date This was what I wrote, and I…
-
COUNTIFS NON Blank Question
I have two columns, "Assigned To" and "Date Entered". What I want is to count blank "Date Entered" cells that are assigned to a specific person. Is this possible?
-
How to automatically copy the approved documents into another grid or sheet?
Hi, I have a grid or sheet where the rows which document status is already "SPC-approved" need to copy or populate to another sheet called "Approved Docs". Is there a way where this Approved-Docs sheet can automatically copy or get those rows with "SPC-approved"? Please lead me to an idea like formulas, automation…
-
Help with Sheet Summary Formulas to Create a Metric Sheet and Dashboard Chart
Hi! I'm managing a retrofit project and the end goal is to create an executive dashboard highlighting key metrics in the form of charts and/or graphs. From what I've found via searches, it seems like I need to utilize the Summary function on a sheet (my rollout schedule, in this case) in order to pull metrics the data into…
-
Limit the use of a dropdown selection to only a single row in a column
Hello, I've developed a sheet that our Project Manager use to generate a Certificate based on a number of criteria. So the Certifcate (a dashboard) pulls the correct data from multiple sources, the user needs to simply select "YES" in the appropriate row per the below screen shot. Can anyone suggest a way that limits only…