-
Cloning a sheet with Index/Match
I am looking to transfer 90% of data from a source sheet to a destination sheet. Currently both sheets are empty. I plan to populate the source sheet by use of a form and hope the destination sheet populates with INDEX/MATCH. The problem I am running into is how to populate the primary key for the destination sheet, to…
-
Formula Not work for only 5 months
Hey All, =COUNTIFS({Request - Create Date}, IFERROR(MONTH(@cell), 0) = [WSSM#]@row, {Request - Create Date}, IFERROR(YEAR(@cell), 0) = Year@row, {Request - Segment}, ="WellMed", {WSS}, ="Accounts Receivable" + COUNTIFS({Complete Create Date}, IFERROR(MONTH(@cell), 0) = [WSSM#]@row, {Complete Create Date},…
-
Dynamic "UNIQUE" Function
Is there any type of function similar to the UNIQUE function in Excel that I can use? I have a Master List on one Sheet (called "QMS Transformations Common List") and I want to use links for the first column on another sheet ("named "QMS Metrics Calculation - Workstreams"). In excel I could use the UNIQUE function, and it…
-
COUNTIFS
Good afternoon all!! First time poster on here and still learning my Smartsheet. Stumped on the formula and looking for some assistance. I'm trying to count the checkboxes in the 2 columns on the sheet below, SUG Scheduled and SUG Completed. What I am trying to do is count it each column for each similar column for the…
-
Survey Scoring
I have a course evaluation, I want to know how i can write a formula to score the drop down. I.E. Strongly Agree =2 agree =1 neither = 0 disagree = -1 strongly disagree = -2. I would assume a countif would do it i just don't know how to write it. and i an guessing i would have to add those together and /10 to get the…
-
Divide by Zero Help
Hello all! I'm trying to calculate an average processing time when certain variables are met. Please see below: =AVG(COLLECT({Support Processing Time}, {Created}, "2023", {Crew Ops Support Team Member}, "Trenton Graf", {Agility Number}, ""), COLLECT({Support Processing Time}, {Created}, "2023", {Crew Ops Support Team…
-
simple comparison
I can't believe I have to ask this, but I cannot turn up a solid answer when I search. I just want to compare Column2 value with Column1 value. I want the formula/result to be in Column3. I get UNPARSEABLE. The best formula I could find was: =IF([TotalRegistered] = [RegistrationCap], "SOLD OUT", ""). The only thing I can…
-
If/Then statement with math equation
I am wanted to create a formula in a Smartsheet that references 1 cell with a "True" response to then subtract 1 from a different cell. For Example: "if[Type of card}=Mobil, then - 1 from [#of cards left Row below] I know this isn't correct verbiage. The data is coming off a form. There are 2 types of cards that can be…
-
Has anyone created an automation to capture open items by month?
We need to report on the items that are unbilled at month's end. The person responsible for this has now left the company and I've been tasked in the interim. I can see this was manually done but they want it automated. What formula would I use to look at the current sheet and see what was still open on May 31st? And then…
-
Can I copy a row to another sheet more than once?
Is it possible to copy a row to another sheet and have it copy multiple times on sheet #2? For example on sheet #1 I have a project with multiple dates for different deliverables within the overall project. I need these projects to copy over to a 2nd sheet where we get a separate line for each date. Right now we are…