-
Simple IF OR Formula
Hi, I would like for the 'Invoice to Cust' Column to update to "No" WHEN 'Cost Recovery' is either "Blank to Invoice" OR "Operation to Invoice". ^Apart from this, if it is doable; I would like to add to this formula of WHEN 'Status' is "To be Invoiced" will update 'Invoice to Cust' to "PENDING" However, if the last ask is…
-
Searching a column in another sheet
Hi, I'm trying to reference contact info from one sheet and have it show up in another as I type. I want the second sheet to search a column as I type and match the contact name if it exists. Does smartsheet have a vlookup or something that can search another column in real-time as I type. An alternative would be a drop…
-
using if functions to perform multiple logical evaluations
I am needing to look at one cell to see if it has a specific word and then if it does use networkdays to calculate using two other cells. I am able to do this in excel, but unable to find the correct formula to do in smartsheet. Below is an example of what I used in creating it in excel.…
-
How to Sum Cells with Numbers & Text
Have a super basic question I just can't seem to find a quick answer for. Want to sum cells with both numbers and text in them like "15 min" + "15 min" and get the result of "30 min". I formatted the cell with the following formula: =15 + " min" Result: 15 min When I add 2 cells with that formula [=15 + " min"] + [=15 + "…
-
Formula / Function to copy cells from one sheet to another
Does Smartsheets have a function or formula that will copy a cell from one sheet to another without the manual copy/paste process? For example, I have a sheet (CDA 1) that will be used to scan a barcode into a cell (Column2 - Row1). I have a second sheet (CDA 2) that I want to auto-populate what was scanned into the cell…
-
Stoplight turn red when equal or greater than due date
Hi, I am a relatively new smartsheet user. I am using this formula to turn a stoplight red, yellow, green based on the proximity of the due date. The yellow and green portion is working as desired, but the Red is not. I want the health to turn “Red” if the due date is = or greater than TODAY. For some reason, it’s only…
-
Count Number of Records in current year
Hello. I am trying to use a COUNTIFS formula to count the number of records in a second sheet that meet two criteria; the Project Status of the record matches the project status of the row where the formula is, and the year of the Move-In Date of the record is the same as the current year. I have the formula in the pic…
-
Doing two things in one IF statement
WHAT I'M TRYING TO DO: I would like to accomplish two things in one IF statement. Something like: =IF([This Column]@row = 1, [That Column]=true ALSO Today(), ....) WHY I'M TRYING TO DO THIS: I am trying to automate the Actual Finish column in my project management sheets such that, when % Complete reaches 100, then check a…
-
Date Formula Problem
See attached. I am having problems with the date date formula. I add 12 months to the moths and the year does not change. The formula is set up to add # of months(MONTHS) to the start date (SDATE) to calculate and populate the end date (EDATE). It seems the formula works so long as the start date and end date are in the…
-
Is There Really No Built-in Log\NL Function?
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…