-
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β¦
-
Empty cells with #invalid operation
Hello: I create this formula : ="Q" + ROUNDUP((MONTH([Audit Due Date]@row) / 3)) + " " + YEAR([Audit Due Date]@row) for Quarters and year automatic entries based on a column named Audit Due Date. But, when there's no dates on Audit Due Date, then, it appear #invalid operation on Quarters column I tried to consolidate thisβ¦
-
Formula for Moving Specific Columns from one sheet to another
Hi Guys I have a few smartsheets that I'm working on. 1.Master Sheet 2.Construction Phase 3.Completion Phase All these have some specific same columns. The data will be initially entered in the Master Sheet which will have a column " Next Phase" with a drop down list. Once someone changes the next phase to Constructionβ¦
-
Help Needed
Hello, All. I need to create a formula where I am summing particular values in the same column wherever that value appears. For example, if 1 appears 5 times in the column, I wish the formula to return 5. However, I also wish this formula to sum up 2 other values in the column if they appear (column value equals thatβ¦
-
Can't add formula to existing Column
I have a %complete column that is used as an input to other formulas in the sheet but has no formula added to it specifically. I am trying to add a formula to calculate the percentage based on the difference in start and end dates. This formula works well in other sheets. However, when I try to add any logic beginning withβ¦
-
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
-
Issues with Countif and HAS formula
Hi Smartsheets, I am trying to understand how many projects received were made in active each month. The column indicating the month is was made inactive has two lines of content, so the formula require a HAS @Cell. Also cross referencing a difference sheet. The formula I am currently trying is: =COUNTIF({other sheetβ¦