-
Countifs and Is not blank
I am trying to create a formula where it counts the number of rows when an invoice has not been approved. This is what I have and instead of changing the name for each person, I want to create one where it counts when the Approver column is not blank. =COUNTIFS({Approver4}, "Eric Delie", {Hold}, "")
-
Summing entire sheet, but only higher number with similar items.
Okay so I'm trying to create a rough budget for a project, but have received multiple bids for some categories. I want to sum all the items cost, but with multiple items, only take the higher cost. Here's roughly what I mean: Item Price Appliances 12000 Appliances 10000 Glass 8000 Stone 7000 So I want to sum the price…
-
Repeating # formula
this is what i have - but not working IF([row #]18, =1, "2", OR(IF([row #]18, =2, "3", OR(IF([row #]18, =3, "4", OR(IF([row #]18, =4, "5", OR(IF([row #]18, =5, "6", OR(IF([row #]18, =6, "7", OR(IF([row #]18, =7, "8", OR(IF([row #]18, =8, "9", OR(IF([row #]18, =9, "1", i want if the row above is a 1, the next row to equal 2…
-
Looking to time stamp when a box is checked
When a box is checked, I would like to add a time stamp of when that happens. I can put together a formula that involves today's date but I do not want that date field to change every time the sheet is refreshed. I want to be able to run reports capturing start and end dates for project phases. Does anyone know if it's…
-
Formulas -Automated at risk status
Hi all, I'm quite new and I'm struggling with a formula I need to apply. I need to have an automated "at risk" status (red, yellow, green) in my projects masterlist. Red: % Done is equal to 0% and the Start Date has passed Yellow: % Done is bigger than 1% Green: % Done is 100% the formula I'm coming is this: =IF([% Done]1…
-
Resources Tracking
Hello anyone, Please i need some help. My goal is to be able track resources and show forecast in the resource view. If I am correct. i know i have do some calculations or use formulas which i have problem doing that. The data presented to me was Title of the Resource # of people that work in June-Sept total hours worked i…
-
Calculating SUM based of criteria from multiselect.
Good day, I have a form with quite a few multi selects. After a user selects all that apply, I want to cross reference what he selected with a second sheet that has "costs values" associated to the same text that the user had available to him in the multi select drop down on the form. So basically after the user fills out…
-
Formula Help: Auto updating the stars
Hi, I'm working with a semester type project and would like to have the Star symbol used to represent the semester they are in based on a start date. I tried following the example.. .. but I think I'm missing something. Here is the Formula I'm trying to use, based on another example I found. =IF([Start Date]@row < TODAY(),…
-
vlook up - index/match doesn't work
I would like to consolidate multiple source sheets into one destination sheet. Let say, when a row is added to the sheet, it will automatically pop up on the master plan.
-
IF Statement result brings back another cell value
Good morning everyone! I am fairly new to Smartsheet so please spare my dumb question but I really need the help of the experts solving a formula logic: Scenario: I have a list of Events, Attendees and a column with a IF = Month(Today()) formula based on the event date to know what Events took place in the current Month.…
