-
Extract the first word from a cell
Hi, In 1 column I have a string that has 1 word then 2 or more words after that, how do I extract from the column the first word only? In excel I'd use the following =TRIM(LEFT(A2, FIND("^",SUBSTITUTE(A2, " ", "^",1)&"^"))) In Smartsheet there's no TRIM.. The below formula returns the value of the first and second word,…
-
VLOOKUP Lag In Updating
Hi all - I'm connecting two sheets via a VLOOKUP to get a value (Status). I'm seeing a 2+ min lag in the delay in the update of the VLOOKUP - which I've never seen before. It's always been nearly automatic. Even though there are only a few formulas, the VLOOKUP spans only two columns and there are only 50 or so rows, the…
-
Using most recently added row to populate dashboard
Hi - I'm building a dashboard for project reporting, and need the most recently updated row from my data sheet to be used to populate the Metric Widgets. The data needs to come from a sheet rather than a report as I want to display the data split out into areas, not all in one place. I've done a lot of reading, and so far…
-
Subtract date from previous row
Hi, i need to subtract a date-time rows from consecutive row ID as a formula. example: Row ID: JA001, Row Date-time: 01/09/23 10:53 AM Row ID: JA002, Row Date-time: 01/09/23 10:49 AM can you help me? Regards
-
Join/Collect? Formula to record text in a row on if a box is checked on sheet one ...
I am trying to put a formula on Sheet 1 in Column 2 that references Sheet 2, column 2 (DBE)( checkbox) - if the box is checked on Sheet 2, The text from Column 1 (Vendor) will all populate with a comma between each on Column 2 on Sheet 1 SHEET 1 SHEET 2 Thank you! I'm stumped on this one!
-
Date formula previous month for a new year
I'm still getting my head around date formulas, I have one to tell me the start date of the previous month: =IFERROR(DATE(YEAR([Date Column]@row), MONTH([Date Column]@row) - 1, 1), DATE(YEAR([Date Column]@row) + 1, 1, 1)) This worked fine until we changed to a new year, what have I done wrong with this formula?
-
Send a notification when all rows in a sheet are marked as complete
I'm trying to figure out a way for a notification to be triggered when all rows in a sheet are marked as complete. I've tried to create a new column that would have the first cell with a formula that will Enter a 1 if the count of the Status column with Blue equals the count of items in the primary column. So something…
-
#Incorrect Argument Set with =COUNTIFS
Hi all, This is baffling me. I have a very simple formula... =COUNTIFS({Epic Name}, [Primary Column]@row, {Current Sprint}, 1). I am using this for a metrics sheet to be used for dashboard reporting. This is working as expected in it's own sheet but when I use the exact same formula in a bigger/consolidated metric sheet,…
-
How to prevent IF function from removing cell data when false
My team is currently tracking customer services and monthly rate before and after talking with an agent, using a form that I created. I am trying to set up a formula that if we select that there are no changes made to the account it will copy over the data from the incoming fields to the outcoming. I am using this IF…
-
What Formula to use to Count the number of Unique Dropdown Phrase Utilized
I'm new to Smartsheets and I've been tasked with going over the SWOT data. They are asking me to go over each category of SWOT with the unique data point they captured and tallying how many times that data point is utilized. The Data Point Column is a dropdown list. For example, I am having a hard time counting how many…