-
IF NOT ISBLANK help
I'm trying to create a formula that will display the different colored dots in the status bar. I had success at first but one part of the formula isn't working with the others. I need it to display BLANK if Patient is blank, Gray if patient is filled in but Order Request Date is blank, Green if Complete date is filled in,…
-
IF Cell Contains This Text VLOOKUP
Hello, The Status Column has a dropdown menu with multiple options with the text "Completed" and some other options: Completed awaiting Signature Completed Reviewing Completed Approved Failed Inspection I want this formula to work with any options from the drop-down menu with the letter completed. This is what I have so…
-
VLOOKUP with multiple criteria help
Hi, I have a sheet which has 1 column showing a document name, and another column for document revision number. I need to make a vlookup which returns the owner of the doc, based on the document name and revision number. I'm aware that the simplest option is to concatenate the two columns but I'd prefer not to add another…
-
Contact column to return multiple email addresses
Good morning, I have a contact column, then an email address column where I use a Vlookup function to go to another sheet and pull the users email address from. However, when I enter multiple contacts I want a formula to return ALL those email address back to my email address column. I know VLOOKUP isn't it, and I tried…
-
Avg collect Error
Hello Community, I'm running into a bit of an issue. My previous worked fine for the year 2022 but now that we're in 2023 I need to adjust my formula to account for the year change. Below is the formula I had been using which has worked well in 2022. However, now that I'm attempting to collect the avg score from the same…
-
Index & Match formula
Hi Smarties, I have a question on Index and Match formula. I am using the Project Management Office template set from Smartsheet. Based on the Intake sheet, a new project is created, and a number will be auto-assigned (SM-004) I made a few changes by adding in Project Type between Project Name and Project Manager. In…
-
SUMIFS in Smartsheet
Hi all, I'm trying to use SUMIFS in Smartsheet to sum actual hours for individuals between two dates. I'm using two sheets, one is the front facing table and the other is the raw data. I've tried this forumla which worked in excel, but won't work in smartsheet? =SUMIFS(sum_range, individual_range, criteria1, date_range,…
-
I want to count how many cells have a date.
I am trying to find a way to count how many cells in my column have a date in it. I use the formula =COUNT([Target Launch Date]6:[Target Launch Date]24) but it always appears the error code #DATE EXPECTED. I tried the same formula on other columns with text and it works perfectly fine. I also tried =COUNTIF([Target Launch…
-
count number of rows with dates that fall between start and finish date which have box unchecked
I have a sheet which is referencing another sheet. We would like to count the number or rows which have a date (on the referencing sheet) that falls between the start & finish date but the checkbox (on the referencing sheet) is unchecked. I have the countifs formula for counting the number of rows between the date. But not…
-
Duration in hours formula returning #INVALID VALUE
Hello, trying to calculate the duration in hours between two dates, see below: But the formula returns #INVALID VALUE. After reading another help post, I have edited the column properties so that the data type is date, but doing so removed the time stamp and the formula still returms #INVALID VALUE. So now I have two…
