-
Need help with seeing if a cell contains the quote symbol.
I want to locate " in a cell but Smartsheet wont allow me to run the following: =IF(CONTAINS(" " ",[Column]@row),1,0) Is there some sort of symbol that will allow me to reference this in the quotations of the formula or is there another way to locate this symbol in a cell that I am missing? Using this in a helper column to…
-
Pulling Data Based on Certain Criteria
Hello Community, I have a situation where I am trying to pull data from 3+ columns based on a few input fields (city, country, engineer level). We want to output the primary company, secondary company, and third company once this data is inputted. On my base sheet, I have a City, State, Country, Engineer Level, Primary…
-
AND statement in smart sheet
I am having issues getting results back when using AND statement I am trying to compare two conditions, and show if an action is late or not using the following formula I want to say if the End date is before today and the completed is blank then the action is late. the line circled in red should show 1 cause both…
-
Need help with a complex formula
Attempting to write a formula in a sheet summary field. Is it possible to write a formula that looks for particular rows based on the text value in one column, and then get the AVG of the numbers in a different column on those selected rows? (ie. If the value in column Task is "Work Order Received", find the average of the…
-
How to find part of a string in another sheet
I have a sheet with a string, say xyz, this is not always the same length. In another sheet an have a column of numbers, which have values which are variable-length strings with values which in the case of the xyz is abcd123xyz I need to find the row that has the xyz is the column. Is there a way to do this?
-
Column isn't an option to filter by
fairly new to smartsheets, why aren't all columns available on the list when making a filter? I did not build this smartsheet but am the owner now so I am not sure if it's something on the backend I may not know yet. I need to create a filter with 4 conditions but only 3 of the 4 columns are options.
-
Complex formula using INDEX MATCH to update other columns
Hello Smartsheet Community, I am trying out how I can do an Index Match to look up data in column 1 and see if the data exists in column 2. If the data exists then update other columns ( like status , health and % Complete, Greatest milestone met) with Values Im truly in a time crunch , and will be super appreciative if…
-
Countifs Function with Multiple Criteria - Best Practices?
Hello! I'm having trouble understanding the best way to count multiple criteria in a countifs function. I can write simple countifs formulas, but the more criterion and ranges I add (seeking "and/or" results), the more errors I get. I struggle with combining ranges and criteria, I think because I don't understand how best…
-
Formula Assistance Needed
Wondering if you could help me with another formula in Smartsheet. What seems off about this one? =SUMIF([Payment Method]:[Payment Method], "", [Payment Amount]:[Payment Amount]),(Territory:Territory),(NOT("International")) I want to sum the "Payment Amount" column IF the "Payment Method" column is blank and IF the…
-
Sum months prior to current month
Hello, hoping someone can help me after trying to search for this issue on the boards. I have columns for every month of the year tracking project $ spent as well as projected to be spent in the future months. I'm trying to use a formula that will track the $ in the columns prior to the current month that can automatically…