-
Help with multiple IF (CONTAINS) AND OR criteria
Hello! I'm trying to figure out how to write a formula to return a value of "Open" or "Closed" when multiple criteria is met, or leave blank if N/A. Columns: "Issue Category (Consolidated)" column contains selections "Invoice Mgmt", "Inventory", etc. "Status" dropdown column = Not Started, In Progress, Completed,…
-
IF and OR nested functions for setting Due Dates based on Project Size
Hi folks, I've been Googling around to try and find some information regarding my challenge. Basically I need to set up this formula to assign a Projected Due date based firstly on the Date of Submission (Date Column) +5 days for a small project or +10 days for a Large project. I have columns filled through for entry for…
-
Using IF and OR function in a formula
I am so close to getting this, but each time I tweak it, I get an UNPARSEABLE message. I am trying to get the Column Titled: Duration (In Hrs) to zero out if EITHER the Not Applicable or Optional rows are checked. The below formula is only making my column 0 out if BOTH the Not Applicable and Optional rows are checked. I'm…
-
#INVALID OPERATION - Error
I'm trying to write an IF/AND formula that references a different sheet to return a single row value. I think where I'm running into a problem is that I need the formula to evaluate three entire columns of data to see if the criteria are met, then return a row level value if all criteria are met on that single row. New…
-
VLOOKUP + Reference Another Sheet
I have been trying to VLOOKUP a value from Sheet A to a table in Sheet B and continue to get #UNPARSEABLE - here is the example I am working with and the formula: =VLOOKUP([Primary Column]3, {test4 Range 1},3,false)) All columns are Text/Number format, the lookup value is in the left-most column. The VLOOKUP formula works…
-
INDEX MATCH Question
Hi everyone, I need a quick hand with an INDEX MATCH formula. I have a form that has users select their store from a drop down. I have two formula columns that use this entry: Region and then Regional Sales Director (RSD). I need to pull Region and RSD from a separate sheet that I don't manage. The column layout is shown…
-
Hide the rows with error without blocking the calculation
Hi Guys, I have a scenario here. I need to refer another sheet and I have to skip the count when the cell have any error. How should I perform that in smartsheet. Can anyone help with this one? With Regard lepote Jo
-
Populating a Date field using formulas
Hi All, I have 2 known variables that I want to use to populate a Date field: We know the date that a Learner starts a course [Start_Date], and we know the cadence at which a report should be pulled afterward [Report_Cadence] (sometimes in weeks, sometimes in weeks + days). I am having trouble creating a formal that will…
-
Currency Symbols in SUM Formula
Hi I am using the SUM formula to total a column cost in my sheet summary. How do I get the £ symbol to show in the sheet summary field so, that when I pull it onto my dashboard it display as a currency figure rather than a random number? I know it's going to end up being something super simple! 🤔
-
Use OR in a formula
Hello. I am working on a formula and I have most of it complete. I have never used the OR function, but I think that is what I need to make this work correctly. Maybe it's just me, but I never really understand how to use it from just the Smartsheet examples. Here is my current formula: =COUNTIFS({WO Tickets…