-
Formula to show if certain cells are blank change the status to red, yellow, or green
I have a sheet where we want to show if the columns successor 1, 2, and 3 are blank the status column should be red. If only successor 1 is filled out status should be yellow If successor 1 and 2 are filled out staus should also be yellow If all 3 successor columns are filled out the status should be green. Pretty much…
-
Indicating Each Month A Project Is Active?
Community, I'm struggling to indicate which months a project is active given a project start and end date. If a project starts on 09 January 2020 and ends on 09 March 2020, it would be active January, February, March. I would like to represent this as follows: Showing that the project was active in its Start Month and End…
-
Populate a cell with all corresponding values in a multi-select drop down cell
Hello, I have a column in my sheet that is populated by a multi-select drop down in a form ("Violation" column below). Once submitted, the cells in this row will contain at least one, but typically multiple entries from the multi-select drop down. Once submitted, I would like two other cells to populate with the…
-
VLookUp Inconsistently Pulling Data
I have a sheet with multiple triggers. Form populates row and assigns a Row ID Client receives a request to update info on that row Once completed, a user is notified to print out the responses for distribution I had to create a work around because there is not a way to nicely print out individual rows Used the VLookUp…
-
Formula to Look Up Multiple Contact Columns
Hi There! I am creating a formula that will assign contacts to a row based on user role plus some other attributes. I am finding the look up is working great for assigning 1 contact, but when I extend the formula to include multiple v-look ups, its displaying the 2 users names as text. For example it will come back…
-
Countifs syntax killing me
I want to count number of projects on hold AND change control = resource constraints This is what I"ve tried; =COUNTIFs([Portfolio Rollups Range 8], "Hold", {Portfolio Rollups Range 9}, "Resource Constraints")
-
How do i write a formula to calculate YTD totals of a given category
Here is the formula i started with. It gives me a #unparceable response =SUMIFS(Amount:Amount, [Expense Category]:[Expense Category], Description@row), Date:Date, YEAR(@cell) = YEAR(TODAY())) Ive included a screen shot
-
SUMIF statement based on dates
I would like to create a SUMIF equation to only sum data (column F) based on a date range (column B) . It works in excel with the following equation for reference. =SUMIF($B$9:$B$2000, ">=9/1/2018", $F$9:$F$2000)-SUMIF($B$9:$B$2000, ">=9/30/2018", $F$9:$F$2000) However, when I import it to smartsheets, I get an error. My…
-
Week Number stopped working
Hi All, I'm a little stumped, I have a formula that worked great until last week when it stopped working. I figured it was just because it was week 1 and week 52 in the same week and figured it would all start working this week. No dice, any help is appreciated. The formula is a helper column that is meant to count the…
-
[help] multiple IF formula; ancestor function?
Hi everybody! I've been testing smartsheet for a month and I was just setting up a document by myself when I found a mistake in my own logic. This is the formula I'm using: =IF(AND(ISBLANK([delivered by]@row); [start date]@row > TODAY()); "to do"; IF(AND(ISBLANK([delivered by]@row); [start date]@row <= TODAY(); [end…