-
Copy Information if condition is met
Formula: =IF([Issue Type]@row= 'Coordinator Request',[Coordinator Request Types]@row, IF([Issue Type]@row= 'Standard Request', [Ops Requests]@row, IF([Issue Type]@row= 'Enhancement Request', [Ops Requests]@row, IF([Issue Type]@row= ‘Change Request', [Ops Requests]@row, Summary@row )))) Goal: If specifc issue type copy…
-
Olga Salcido
In a shared Smartsheet that has undergone multiple changes and updates to rows, columns and formatting, there once was a formula that worked for all the columns, but somehow some of those rows are missing that formula. What could be the cause for this?
-
Question on Function Syntax using IF, AND, and OR
I am trying to get an At Risk check box to return a red flag if there is a date in End Date and that date is earlier than the curent date and the Status cell shows one of three statuses. Can't quite get the formula logic. Any suggestions would be wonderful. Thanks! Desired results: End Date is blank = no flag End Date is…
-
Help with index function
I have a separate grid with a 'Mapping Table' (screenshot below) with on the first column the values that can also be found in my final sheet. In the final sheet I also have a column that should show the mapped values. I'm trying to use the INDEX function to pull in the mapped values, and also show 'Pending' in case…
-
IF/AND/OR Statements Help To Check A Box When Criteria Met
Hi, I am trying to write a formula with multiple IF statements with OR and AND to check the appropriate box: I have this so far and get #INCORRECT ARGUMENT: =IF(AND(NOT(ISBLANK([Term Date]@row))), OR(Program@row = "ABC", [Shared Programs]@row, OR(@cell = "ABC / XYZ", @cell = "XYZ / ABC")), 1, 0) Thanks for any help…
-
Can I get 2 auto-number columns?
I have a data set which already has a auto-number system column however I want another auto-number or row number column if possible using some sort of formula. Is this something we can do?
-
#Date expected error
Hi I have to two - "Target Going TAT Time (Day)" which is a text column and "Departure Date from Loading Point" which is a date column. Now I want to add them together in a column called ETA (G) = Target Going TAT Time (Day) + Departure Date from Loading Point The Problem i get an error when 1 of the column are blank, if…
-
Trying to add a condition to an IF statement
Hi, all, I'm trying to combine two statements and I'm getting an invalid data type argument. Here are the two formulas: =IF(COUNTIFS({2023 Teams & POs Range 2}, @cell = [PO #]@row, {2023 Teams & POs Range 1}, @cell = 1) > 0, "yes", "no") ^This formula pulls a value from a checkbox on the 2023 Teams & POs sheet. Right now…
-
Issue combining data of 2 fields
I need to combine data of two fields. 1 field is a dropdown and the other open text. The first option to combine them didn't work: =TEXT([Content Subset]@row, "General") & [Playlist Brand]@row The second option was to convert the 'Content Subset' to text and then combine, but that again didn't work: =TEXT([Content…
-
Countif / sumif ?
Hi everyone, I'm looking for a formula which will give the number I obtain when I filter such as : I want to know how much "Club Readiness" Online we've when "Current System" column is one of the 2 values selected (let's call them "X" and "Y"). I tried with COUNTIFS, and with COUNTFS with IF function nested, but without…