-
Time calculation formula using an IF variable
I am trying to write a formula that counts the number of days we left to finish specific work cases. The end result that I'm trying to calculate is the number of days remaining to work a second level case based on two variables: 1.) how much time is allowed for a specific case type, and 2.) how much time was exhausted…
-
Suggestion for returning data based on selected criteria
I'm looking for some guidance. I would like a cell to return text (category) based on selected criteria (sub category) -- screen shots below. Example: If I select 'Wine' from the drop down, I would like the Category cell to return 'Food & Bev'. I could do an IF statement, however, there are several subcategories in the…
-
SUMIF - FORMULA CAN'T FIND A NUMBER STARTING WITH "0"
Hi, I'm trying to Sum total cost. But it doesn't recognize the number "00000013". Also, if I change the criterion to "13" and switch to another column with =RIGHT,2 formula, from the "00000013" column that would equal "13", it still doesn't work. My formula is =SUMIF({02. BUDGET TRACKER COST CODE}, "00000013", {02. BUDGET…
-
Monthly Updates - Return the Up and Down Symbol.
Hi Dears, I am stetting Up a Task List as per above. I have the Column : "Updates", this is set up for Up and Down Symbol. The propose is to have this UP if the column Jan, Feb, Mar, until Dec is updated between the Panned Start Date and End Start Date, also considering the column Frequency. I have searched for this, but I…
-
Nesting
I am not familiar with how to nest but I believe that is what I need to do. I have a column titled "Stage". The column has three different options. They are high likelihood, medium likelihood and low likelihood. I need to have a separate column that is either 75%, 50% or 25% depending on which likelihood is in the stage…
-
[help] Using SUMIF formula to calculate the sum of a column if between certain dates
Hey y'all! Here's what I have so far: =SUMIF({GRAD Student - Support Request Range Complete Date}, AND(<=DATE(2019, 5, 9), >=DATE(2019, 1, 7)), {GRAD Student - Support Request Time Spent Range}) Complete Date = the date range I'm trying to pull from After the "And"= The range I want for the dates. Time Spent = The location…
-
Using Modified Date in a formula returns #date Expected
Hello, I am trying to determine whether or not a row should be added to a weekly report by trying use the modified system column to calculate the associated Friday. e.g. It's Tuesday and I make a change, I want my other column 'Report week end date' to display that upcoming Friday. =IF(WEEKDAY(Modified@row) < 6,…
-
I'm trying to create a formula to map to a matrix
I know that I can't create a matrix in Smartsheet, but I'm working on creating a formula using two columns and need to have it return one of 4 answers. If Column A is less than 3 and Column B is less than 3, then the answer should be "Bottom Left Corner" If Column A is less than 3 and Column B is greater than 3, then the…
-
VLOOKUP & SUMIF
This discussion was created from comments split from: SUMIF value exists, leave blank if cells are blank (nothing to sum). User: Anthony12345678 Post: Having a similar issue. The Only difference is that my cells have the vslookup formula "=VLOOKUP(C3,Data!$D$1:$F$25, 2, FALSE)" in side them. When employees fill out the…
-
Help with adding figures in different columns and row
I'm trying to add Q1 totals with the rest of the quarters of 2019. Here is the formula I'm using, but it isn't working. =[Q1 2019 NBR OF LOCATIONS]22 + [Q2 2019 NBR OF LOCATIONS]44 + [Q3 2019 NBR OF LOCATIONS]81 + [Q4 2019 NBR OF LOCATIONS]112 Am I missing something? Thanks for your help!!! Kitty
