-
Mark Duplicate value
Hello team can someone suggest a simple way to mark cell (or rows) that one of the columns with Duplicate value thanks in advance oded
-
Formula for text columns convert to sum?
Hello, I'm trying to help build a sort of prioritization scorecard into a sheet. We have 4 columns, each with possible values of (example) "A", "B" or "C", and would like to have another column that sums each based on assigning a number value to each dropdown option. So for example, the columns and their possibleโฆ
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,โฆ
-
Check Box & IF Statements
Appreciate some pointers on this if possible.. I have 5ย Columnsย in my Smartsheet.. the first 4 are Check Boxes,ย the 5th is a Text/Number.. Columns as follows.. [North] [East] [South] [West] [Direction] In [Direction], I want to display text dependant on the Checked Boxes status.. it can be any of the first 4 boxes or anyโฆ
-
IFS Statement
I have the following equation I am trying to get working:ย =COUNTIFS({Range 1}, =1, {Range 2}, IFERROR(YEAR(@cell), 0) = 2018, {Range 2}, IFERROR(MONTH(@cell), 0) = January, {Range 3}, OR(@Cell="", @Cell="")) The equation has worked in the past without the or statement at the end. It was once looking for one value here, nowโฆ
-
Incomplete work left to go
Is there a way to calculate work days "left to go" where the task is not marked complete while ignoring simultaneous tasks (tasks that have the same predecessor)? It seems like networkdays should get part of the way there but it seems like i need an "if" statement to look at complete. Is there another way to get there thatโฆ
-
Showing multiple true checkboxes as joined or concatenated text in another column
I have a volunteer submission form which has about 10 columns that exist as just checkboxes on/off - each of these relate to a conference work area and volunteers often select multiple. To easily view the data for a single person/row without tons of scrolling and looking up and down at column titles, I want to aggregateโฆ
-
IF Percentage Complete = 100% return Date
This seemed simple to me before I started.. but this has me foxed..! two columns: % Complete [Text/Number field] Date Complete [Date field] What I intended is for the Date Complete cell to automatically complete with TODAY() when the user updates the "% Complete" cell is set as 100% ..what I have so far is =IF([%โฆ
-
Count Number of Cells that Contain Certain Text?
Hello, I am trying to count the number of cells that contain certain words, such as "NYSEG" or "RGE," when the cells may contain more than one of these words. I have tried usingย =COUNT(FIND("ConEd", [Utilities]:[Utilities])), but it always turns back a 1 (no matter how many cells actually contain "ConEd"). I am trying toโฆ
-
If Then Function
Our Smartsheet form has a โCompletedโ column (it is a date column) and a โStatusโ column (statuses from a drowndown list). We would like to somehow tell the sheet that, if the โCompletedโ cell is a date then change the status to โCompletedโ in the โStatusโ column. Basically when users submit a new form, the status goes inโฆ