-
Combining these three formulas
Can someone help me combine these three formulas to result in one final Answer? =IF(AND([HP Advance Pull Print?]@row = "Yes", [Account Size]@row = "Small"), 56, 0) =IF(AND([HP Advance Pull Print?]@row = "Yes", [Account Size]@row = "Medium"), 112, 0) =IF(AND([HP Advance Pull Print?]@row = "Yes", [Account Size]@row =…
-
Formula Challenge Sheet
Hello! I remember I used to own a sheet called Smartsheet Formula Challenge (there are race cars visual in the sheet) that has few good scenarios/challenges on Formulas which I have been using as a reference! However, since I moved job, I dont have a copy of that anymore neither I know where to find them! Does anyone has…
-
Cross Sheet Formula with One Criteria
Hello, I am creating Smartsheets for quality assurance testing. Sheet #1 will be the test scenarios and steps taken. The row will include a drop down menu to indicate if the step passed, failed, etc. I need a formula that if "Fail" is selected from the drop down menu, the step's ID # will automatically pull into Sheet #2…
-
MAX COLLECT with IF?
Hi everyone I would like to feed a graph as follows: Please show me the last 5 days in the yellow assigned cells in sequence of date, that had a value in column 1, so I can display the value in a graph. Any suggestions?
-
VLOOKUP # of Row/Range
I created a cross-sheet VLOOKUP that will update status from one sheet to the next. The functionality works but the issue I cannot resolve is, on the reference sheet, I want the VLOOKUP to always review the first 500 rows of data. I can't find where I'd be able to direct it to always review 500 rows. It seems to truncate…
-
What is wrong with this formula?
The following formula appears in one of our Smartsheets as a column formula: =IF(Holidays@row <> "", IF(TODAY() >= Holidays@row, COUNTIFS({Course Complete Date}, Holidays@row, ""), "")) This formula had been functioning as intended for quite some time, but it started yielding an #INCORRECT ARGUMENT SET error a few days…
-
Adding days to a Date to determine a future date
I am trying to create a formula that will look at the date within the row, look at the frequency and then determine what the next date will be. I am using the following formula: =[Estimated Date of Charge]@row + [Frequency in Days]@row Here is the result: The system is just populating the date in the Estimated Date of…
-
trying to convert a row to column formula using IFERROR
using NETDAYS to calculate days between dates, and an IFERROR to have Blank populated. This works in the row just fine, When I try to convert to a column formula, I add @row to the cell and it becomes #UNPARSABLE. Before adding @ROW tried to convert to column formula and get the following. Help!!!! formula that is working…
-
Need a second pair of eyes on this formula please
Ok, I'm going crazy. I have used this formula 3 times already on my roll up sheet and it's working just fine, but suddenly I'm getting an INCORRECT ARGUMENT error. I've been staring at formulas all day...am I missing something here?? =COUNTIFS({Program Schedule - Shell Mobility pt 4 Range 1}, "Stage 2", {Program Schedule -…
-
Calculate Average Time
Hi Team, I have one sheet that calculates the time duration that a tech is onsite per line, but what I need to do is in another sheet calculate the average time TOTAL for all entries. I'm having trouble figuring out how to accomplish this. Thanks in advance for everyone's assistance!
