IF(
Discussion List
- Hi, I have two sheets that I am working with. One sheet has a URL that I want to copy over to the other sheet. Both sheets have an identifier column titled "Org Unit ID". I have trying to write a form…
- Hi, I am trying to write a formula that will take a value from the sheet the formula is in and check for that value in other sheets. If the value is found in at least one other sheet, the formula shou…
- Writing formulas is not a strong suite of mine - I've tried a few routes (IF OR AND) but I'm either running into invalid formulas or formulas that are not netting the right results. I am trying to wri…
- I have a sheet where every row requires two approvals before it's fully approved. What would the formula be to make this work? For example, approval column 1 is named "initial approval" and approval c…
- I am trying to gather information from another sheet and then (possibly) use an =IF statement to format another sheet, but I can't figure out the formula that I need to use. A little more information:…
- Hello, I am trying to write an IF formula for my smartsheet that adds the letter A, B, C or D or E to a column pending on a dollar amount listed in another column, but I cannot seem to get the ranges …
- Hello! I am trying to figure out if I can do a sort of conditional text entry. For example, if I enter "St. Bernard" in a cell in column A, then the cell in same row of column B would auto-fill with t…
- Hi, I currently have a spreadsheet in Excel I am moving to Smartsheet with an IF formula. Can someone help translate what this formula should be in Smartsheet? In Excel, the Current Widget Liabilities…
- I am trying to populate a cell based on multiple date criteria. I am currently trying to use the below formula but I am getting an unparseable error =IF([Date Submitted]@row > DATE(2024, 9, 30), 25, "…
- Hi, I'm trying to write a formula to return different values based on the reference date ([Next Calibration/PM Date]@row) compared to today's date. I want the equation to: If the cell is blank, return…