-
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.β¦
-
IF statement to return an arrow?
Hello, I am trying to get Smartsheet to return an arrow if a certain cell's value is greater than, equal to, or less than zero. I wrote this function to do this but it does not results in anything: =IF([Change in cFTE]@row < 0, "Down", IF([Change in cFTE]@row = 0, "Unchanged", IF([Change in cFTE] 0, "Up", "Blank"))) I'dβ¦
-
What formula to use to show how status changes depending on days prior to due date
What formula would I use to show the following: Project not started 20+ days prior to due date, status = green Project not started 15-19 days prior to due date, status = yellow Project not started < 15 days prior to due date, status = red
-
Using CountIF function to calculate Count of Market
Hi! I'm looking to get some help on a CountIF formula. I have a sheet "Territory 4 Exit Interview Pivot Table" which I am looking to get a count of how many employees are in Market 41, 42, 43, and 44 (from the T4 Exit Interview Results sheet screenshot). I keep getting all sorts of errors when trying to use the CountIFβ¦
-
Countifs, multiple ranges and criteria coming back wrong.
I am attempting to count all projects with 4 different criteria, each criteria is under a separate column. I am using the formula below is for some reason it is coming back with 1 more than in the sheet. After I find this total count I am also trying to count out of those projects how many for completed and again its offβ¦
-
Tracking project's resources with formulas
Hello, My problem is that Iβm trying to create a formula that would check if one worker (resource) has more than one project at the same time. I have used following formulas: Formula that checks if projects overlap: =IF(COUNTIFS([Finish date]:[Finish date]; >[Start date]@row; [Start date]:[Start date]; <[Finish date]@row)β¦
-
Issue with countifs statement when there's an if statement
My countifs statement is this =COUNTIFS({Tech 1}, $Tech@row, {Start 1}, <=[6.00]$1, {End 1}, >[6.00]$1) and the formula in the column it's looking in is this =IF(AND(Split@row = 1, [Required Staff]@row > 1), IFERROR(LEFT([Tech 1 Hours]@row, FIND("-", [Tech 1 Hours]@row) - 1), [Start Time]@row), [Start Time]@row) As long asβ¦