-
Count 2 text fields in multi-select options
Hi there - I'm trying to count if a row has any of of the selections "Briefs" or "All Communications", but not when the row only "Events" or is blank. The report pulls correctly when I choose "Any of" those two in the multi-select, but I want to write a formula in the summary so I can pull it onto a dashboard. I feel like…
-
RGB Formula for Multi-Dropdown
Hi - I'm looking for some help with a formula. I am using multiple RGB fields and would like the RGB to appear as Green unless its Area is selected from the multi-dropdown field where it would then be red. RGB Area 1 - Green (or Red if selected in Dropdown) RGB Area 2 - Green (or Red if selected in Dropdown) RGB Area 3 -…
-
duplicates formula
Hi Experts: I would like to identify the duplicated in column Model# and than mark the once which have the lowest article#. The one marked in red are the once which should be marked in column model count. It's getting complicate as the article# is build out of letter and numbers, it's build in alphabetical order. Do you…
-
Using sumifs to tally up certain date ranges
Hi All. I'm working to understand the more complex formulas of smartsheet but have been stumped. I'm looking to sum the work area total amount of a task based on the start and finish dates on the Gantt chart. I want to see what we will bill per month. The Gantt has each work area with dates and work area pricing totals. I…
-
Smartsheet formula
Hi, Some help would be great if possible, I need to get this working on an if statement if possible. I need it to look for a [Range_Complexity]@row called "Complex" and if so change the formula to this =WORKDAY([Lock Off (Online -6 Weeks)]@row, -DRCOUNTCOMPLEX#, {Holidays Range 3}) Std Formula if it does not find the word…
-
Formula for Count with multi-select columns
I've been trying to figure out how to write the formula to determine how often a specific multi-select option has been selected in a single column and I keep hitting a wall. This is what I have, but I think it needs to be a "COUNTIF" statement because the result I'm getting by using a "COUNT" statement is incorrect; I…
-
IF/OR Quarters Formula
Hello! I am trying to come up with a formula to assign Quarters to a sheet, based on if the month is 1, 2, 3, etc. (Jan, Feb, Mar, etc.) I am trying to use IF(OR and I get it to work until Q2, but for some reason when I add Q3 section (highlighted) it is saying syntax is wrong. It is probably something obvious that I am…
-
Looking for most recent date
I have two sheets. The first is a tracker for up coming reoccurring tasks and the second is a copy of rows that have been completed. In the first sheet I would like to collect the date from the "date" column in the second sheet if the "Combined" column values match that on the first sheet and if "Most Recent" is checked in…
-
Is there a way to calculate the change of role in percentage?
Hi, I have a tracker, whenever the role/status change, it'll copy to this sheet. I'm trying to find a formula to calculate the change % from coordinator to admin, and from admin to the coordinator. Is there a way to do so? TIA!
-
Nested If Statement Not Working
I am trying to write a nested IF statement to automate the RYG status balls in a status column. It will not work, it always say they are red. What am I doing wrong? Logic Needed: If less than 70% complete, "Red" status ball If 70% or above and less than 100% complete, "Yellow" status ball If 100% complete, "Green" status…
