-
COUNTIF's and CONTAINS
Hi, I'm trying to create a formula to COUNT specific project type and a particular team name listing on the same reference list. The columns are not co-located, so I'm using 2 separate references. The team name is within a multi-select field (reference {Team} below), and the current formula does not pick up when multipleβ¦
-
Linking sheets - data consolidation on another sheet
Hi Everyone, I would like to count the total number of 'In progress' in status column for 'Niger' in Region column on a separate sheet. I tried using the formula below but it is giving me #UNPARSEABLE on the new sheet (destination sheet) =({ICAP NG State-TECHNICAL Work Plan - FY 21 Range 1}), =IF(Region@row = ("Niger"),β¦
-
Dependencies - Delay of one month
Hi, currently working on a "calculator" that distributes dates based on the "Start date" input from the user. I need to use dependencies, however I don't find a way to include 1 month as a delay (if the input date is 25/08, then the next date is 25/09). Is there a way to achieve this ? I was using formulas before, but youβ¦
-
RAG status based on dates overdue
Hi, I'm attempting to get an output of either, "On Track", "Overdue" or "Critically Overdue" for baseline milestone dates in Smartsheet, with the Overdue being 5 days over & Critically overdue being 20 days over respectively. I have drafted the initial IF statement, however i'm suck on how to add the additional "Criticallyβ¦
-
Conditioning Formating
How do you set condition formating in a column using RAG bubbles for the following conditions: Green bubble should appear if the temperature is 118-130 F Yellow bubble if temperature is <118 F Red bubble if temp is 130 F
-
Date Overlapping Formula with Same Resources
Hi Smarties, I am working on a challenge below hoping for some help. I would like to raise a flag (on a flag column), if Start Date and End Date of a project conflict with other Start Date and End Date. Projects are the ones with Header "0" Only if the Start Date and End Date of the projects are assigned to the sameβ¦
-
Summing the multiplication of two columns
Hello, I would like to know how to use a formula to multiply two columns and sum the results over multiple rows. My columns are "salary" and "percent_work" (that is, 1.0 = full time, 0.5 = half time, etc.). My rows are the employees. I need to multiply salary * percent_work and sum over all employees to obtain the totalβ¦
-
COUNTIFS for cell value between 2 limits
Hi everyone, I'm using the appended formula to count the number of times the cell values in a column fall between two limits. =COUNTIFS({Summary sheet Family}, "Cups", {summary sheet install phase}, "Storage", {summary sheet Storage duration}, >=[Metric1,]26 < [Metric2]26) The above formula works without error, but doesβ¦
-
Cell History Changing Due to Time Zone for Column Formula?
Hi, I have a column level formula and the oddest thing is happening. My cell value keeps changing to a swapping date when the actual cell containing the date has not changed (cell history checked). I'm hunching that a user is using different timezone date format which is why the dates flip between MM/DD and DD/MM and backβ¦
-
Forms or Formulas with appointment scheduling
Hello All! hope you can assist. Trying to have a form (external users fill out) to book a time slot - Once that time is gone - no longer available to anyone else and thus is removed from the options. Is there a solution, formula or best way to achieve this without using a third party booking tool? π€ Thanks Trishπ