-
How do pull specific text from a string of text like a URL
/(maps;id=default;@=41.13015856427597,-96.15103612629356,19//sp:jobs) I want to pull the latitude and longitude coordinates from the text above into separate cells. I know how to do it in excel but don't know the SmartSheet equivalent. Excel formula: URL Link is in B6 cell. Lat:…
-
Sheet Reference Formula Unparseable Error
I'm using the following formula, which references another sheet to pull in definitions/text: =IF([Job Family Recommendation]@row = "Accounting Operations", {Job Family Definitions Range 5}), IF([Job Family Recommendation]@row = "Billing", {Job Family Definitions Range 2}) The first leg of the formula works, but when I add…
-
How do you limit items in a dropdown menu field based on the selection of another?
We're building a process where users are limited to a secondary dropdown menu selection after selecting an option from another dropdown field. For example: We have a Job Department field and a Job Type field. If the Job Department dropdown menu includes Accounting, HR, IT, etc., we want the Job Type field to be limited to…
-
Multiple Counts of Project Type Column but Exclude if Complete from Status Column
I'm trying to count in my 'Type' column those labeled as "Business Planning", "HRO", "Operational Transformation", "Analytic Support" and "Strategic Implementation" while EXCLUDING those labeled as "Tasks" and then I want to EXCLUDE those 'Types' that are marked as 'Complete" or "Canceled' and only capture those labeled as…
-
Help with Unparseable If(And) formula
Please help with reviewing the formula below. I am getting #UNPARSEABLE. =IF(AND([Spend 2022]@row=0,[Spend 2023]@row=0,[Compliance Status]@row<>”Active-NonCompliant”),"Y", "N") If I only do the single IF, it returns the value correctly : =IF([Spend 2022]@row = 0, "Y", "N") [Spend 2022] and [Spend 2023] columns are text…
-
Sumifs forumla with unparseable error. What am I doing wrong?
I am using a sumifs formula to sum a column from another sheet. My formula is =SUMIFS({CRA MV Report Metrics Range 5}}, [CRA Name]@row, {CRA MV Report Metrics Range 2}, [Visit Type]@row, {CRA MV Report Metrics Range 4}, [Visit Type Description]@row, {CRA MV Report Metrics Range 3}) Is there something wrong with my formula?
-
How do I find/calculate the available (latest) date from multiple rows WHERE there is a condition
Intent: Calculate date team member is available I have a resource planning sheet, which lists a number of activities (by row) for team members. Each row describes the team member, activity, the status, and the start and end date. How do I find the latest end date for each team member, where there activity is 'In Progress'?…
-
Formula for % Complete
Hello, I have a question on formulas. In the screen print below, I am trying to write a formula that counts the number of "Complete" amongst a list of other status' and gives me the overall % complete. I think the formula I've written isn't correct. Can you please assist on where I have gone wrong?
-
How to break down the result into each row?
good morning guys, I have used the formula to extract the name of the trading partners as below. There is 3 of them ( Caterpillar, Tesla and John Deere. However, all of them are in one row. is it possible to split them into each rows as below? Thanks!
-
SUMIFS and CRITERIA where @cell date = date in associated row in another column
Hello friends, Basic need description: SUM the invoice amounts in Column A IF date in Column B = date in Column C Using SUMIFS function: I am trying to SUM $'s in Column: "💲 Total Rental $ Amount {H}" → if @cell date in Column: "📅 System Date" = date in Column: "📅 Today {H} 🅰" Column: "📅 Today {H} 🅰" is populated every…