-
Use index, match and left to match a set of strings from another sheet
Hello, I am using the formula below in order to match two data sets together. It works fine. For my next task I am trying to limit the match to only the first 12 characters of the string. I am trying to fit in the left function and using 12 as the character count, but I am getting errors. Here is the current formula I am…
-
Formula in Sheet Summary returns different count result than filter
I am trying to count new entries in a list added during the previous week. If I filter data on "Create Date" between the dates for Sun-Sat last week (eg 8/3/2025 and 8/9/2025) I get result A (65). In my sheet summary I used this formula: =COUNTIF([Create Date]:[Create Date], IFERROR(WEEKNUMBER(@cell ), 0) =…
-
Can I have a column calculate and store a counter and restart for a new group?
Is it possible to have a column calculate a counter that restarts when another column's value changes? What I mean, imagine 3 columns: * Event name * Topic name * Feature number I want to make Feature number a counter. And I want the counter to restart every time the Event name and Topic name changes. I have a feeling it…
-
How do I stop rounding?
Hello! I'm trying to enter tax information for different counties. I need this amount to be 2.0145%, but it keeps rounding to 2.015%. I've added two extra decimal places, and it still rounds to the thousandths place. How can I get the full number to show?
-
Formula to show most recent submission within a shift and a checkbox
I've got a sheet where forms are submitted by QR code when bins are checked each shift and I want the most recent submission for each shift to get a 1 in the checker column. I've got an automation scheduled for each day to move the most recent submission for each shift to another sheet to be kept at the end of the…
-
Removing special characters
Hello! I am importing from excel and ending up with extra characters in the cell. For example, instead of the cell displaying: Spanish, Portugues I am instead seeing: ["Spanish","Portugues"] Is there a formula that would remove the [ ] " from the cell? Thank you!
-
Translating Formula to Smartsheet
Hello, I am working on making a dashboard for some RAIL data. I need to re-create a formula that was written by a BI analyst for Tableau, but I need to do it in Smartsheet. Below is the information. Can anyone please help me write this?
-
Join text based off checkmark columns
Hello, I am trying to join different names into a single column if the checkmark next to them is unchecked. I have my data set up as shown in the table below. The intention is to have the "remaining" column list Person 2 as there is no checkmark next to their name. Is this possible? Remaining Check Owner Check Reviewer…
-
Is there a way to mimic the % Complete formula that Smartsheet uses in the project settings?
My project requires two separate % complete columns in the same sheet. I am trying to find a way to mimic the "formula" that Smartsheet uses to calculate the % Complete when enabled in the project settings. Note: I have selected "dependencies enabled" in the project settings. Is there a way to create a formula that mimics…
-
Help with an INDEX(MATCH(MATCH( Formula
Hey all, I have two sheets: Business Consult and Project Proposal. I'd like to move specific info from that sheet onto the Project Proposal sheet using a unique identifier, the Business Consult ID. I've mirrored columns on both sheets and they are in the same order (though Project Proposal sheet has additional columns). My…