-
What is Unparseable about this formula?
=SUMIFS({Daily Sales Tracking Range 5}, {Daily Sales Tracking Range 2}, >=[Week Start]@row, {Daily Sales Tracking Range 2}, <=[Week End]@row, {Daily Sales Tracking Range 4}, IF(CONTAINS("Better", [{Daily Sales Tracking Range 4}]:[{Daily Sales Tracking Range 4}])))
-
COUNTIFS error
So, a simple formula (that worked before), is now not working: =COUNTIFS([Approved 2024 $$]:[Approved 2024 $$], "", [Targeted Area]:[Targeted Area], "Atopic Dermatitis") Even if I reverse the [Approved 2024 $$]:[Approved 2024 $$] and put it at the end; it won't look at that column and count those "out". It just counts the…
-
Symbol, Checkbox, Percent Complete formulas
I have a series of projects listed in a sheet (Sheet 1), each of the projects has a deliverable name. For each deliverable name I have a Symbol, a Checkbox, a Percent Complete, and the Person Accountable. In a separate sheet (Sheet 2) I want to return the results of the Symbol, the Checkbox, the Percent Complete, and the…
-
Sumifs error formula when summing duration time
HI, I have a metric sheet where it is comparing to see person exists on another sheet and if so calculate the durations assigned against all their tasks. I get an #UNPARSEABLE in the formula that I cant figure out. Can anyone advise? =SUMIFS({Michael Johnson Assigned to}, [IT Personnel w no Email]@row, {Michael Johnson…
-
Returning A Symbol Value From Another Sheet
Hi all! I am trying to return a symbol value from a cross sheet reference, and I am having a little bit of difficulty at the moment. I have 2 sheets, we'll call the first sheet (that I am trying to reference) "Trends", and the second sheet "This Week". In "Trends", every row represents a week, and ta the end of every row…
-
Convert date field to month text
Hello! My goal: 01/02/2024 returns a value of January or January 2024 in another cell The column that contains 01/02/2024 is a formula calculating this date. I need to show the month (and year if possible) in text in another column. Is this even possible?
-
Index Match
I am trying to lookup 2 values Sales Order & Part Number on sheet 1 and match them in sheet 2 and display the amount. I have tried 2 versions of the formula with no success First one returns #INVALID OPERATION =INDEX({QuoteandSalesOrderLineDetailRev1LOResults3 Range 2}, MATCH(1, ([SO Number]@row =…
-
Multiple Select Dropdown
Hi all, I don't recall where I read that using multiple select dropdowns was not a good idea. I can't seem to find the reason why. I am creating a sheet that has up to 3 selections in one field and am questioning if its a good idea. Hoping to get the communities opinion on this before I continue with my sheet setup. Thanks…
-
How to add hours in the column if date format is in text/number?
Hi All, New here in Smartsheet. I would like to ask what formula can I use in column 5 to achieve the expected date and time if I add column 2 and column 3. Current Formula in column 4 is =IFERROR([Column 2]row 3 + ([Column 3]row3 / 24), 100) If I put in actual excel file it is working as per expected result in column 5…
-
how to convert inches to feet and inches expressed as 12'6"x12'6"
how to convert inches(150x150) to feet and inches expressed as 12'6"x12'6"