-
IF Formula
Hi everyone, I have two columns. One is Department, the other is Analyst. I have created an if statement under the analyst column saying - =IF([Lead Department]2 = "Education", "Analyst Name". The formula is a lot longer because I added 13 departments in total, but it works. That said, in some cases we need to select…
-
Figuring out the Average within a Week
I am currently trying to figure out how to average the turn time for our projects. In Excel all you have to do is select the number of days each project took for that week and it shows you the average. I can't seem to figure out how to do that in Smartsheet. I have a column for Week Number. The total is also based on the…
-
What is wrong with my IF formula
=IF([Transportation Type]@row ="Rental Car", "CWT Code Required”, IF([Transportation Type]@row=”Air”, "CWT Code Required" ,IF([Transportation Type]@row=”Train”, "CWT Code Required")))
-
Current vs. Next Due Date
We have a list of software/hardware/contract obligations. Currently it is setup to provide 30, 60, and 90 day reminders (based on current the due date) to the interested parties so our contracts and licenses do not expire. I am wondering if there is a way to update a renewal date for the following year once it has been…
-
Count if the cell in two different columns is blank
I am trying to do a conditional count if 2 columns from the same spreadsheet is blank. Here is the formula I am using that is coming up with an error message. With Column 1 being CT BAY and Column 2 Being Range Baylor. In other word if both these columns are blank then to count it. This is the formula I am using am I doing…
-
IF(OR formula for a Checkbox
I believe this is simple, but I am #UNPARSEABLE error. I have 5 approval columns with Approved, Denied or Received. I want to check all 5 columns, if any one of the columns has received, then select the checkbox. Here is what I have now, what's missing? =IF(OR([Approval1]@row, ="Received", [Approval2]@row, ="Received",…
-
I'm stuck trying to do some basic arithmetic using the YEAR function
I'm trying to derive the number of years that have passed since a boat was either built or underwent a major refit. I have one column for date built and another for date of last refit. First, I wanted to return a blank if there is no last refit date, and then to calculate the number of years since the last refit if there…
-
How do I combine the following formulas?
=IF(LEN[Cardholder Employee ID]@row = 9, "Yes") =IF(LEN[Cardholder Employee ID]@row <> 9, "No") Or how to count the number of numerical characters in a cell? the count is not working for some reason Sandi
-
Using OR with COUNTIF function
I have a sheet with a "Start Date" column and a "Completed Date" column, and I am trying to get the month end count, meaning it was either started OR completed in September. Both columns are formatted as "Date" columns. Can anyone help me? Thank you! -Erica
-
Alert Me When A New Sheet Is Created
Hi there, Is it possible to create an alert, that when someone in my team ads a sheet, I as admin should get notified?