-
Health and Status roll up from task to child to parent
My roll-up formula in my parent row is working perfectly and captures the information from its primary children rows. =IF(COUNTIFS(CHILDREN(), "Red") > 0, "Red", IF(COUNTIFS(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIFS(CHILDREN(), "Green") = COUNT(CHILDREN()), "Green", IF(COUNTIFS(CHILDREN(), "Blue") =…
-
Formula for checkbox if meets criteria
Hi, I've kind of asked this question before, but the formula that was suggested doesn't work on multiple dates. I have sheet A and Sheet B Sheet A has columns of ID# and Date Sheet B has columns of ID#, Date 1, Date 2, Date 3 etc... The formula I have in sheet B didn't work when there is a different date column in the same…
-
Updating "master" task sheet status from six sub-project task sheets
I want to keep task sheets for six projects. I want them to feed to a "master" sheet. I have successfully created the automations to copy tasks as added to the six sheets to the master. Where I am struggling is in updating the master as tasks move from "new" to "in process" to "complete". I don't want to use an automation…
-
Conditional logic in a form
I have created a form with conditional logic. The logic displays "catalog responsible" (column was previously set as contact list) and it is displayed only if the previous field is selected with "prod" option (column is set as dropdown) The form works perfectly, but since other group of persons will have access to the data…
-
SumIf
I am trying to use the SUMIF Formula to reference a sheet to add hours based on the name of an employee. I have a Names Column with a list of names and an Hours Column. On a second sheet I am trying to print out their hours added together based on their name. My attempt =SUMIF ({HoursCol}, Name@row = {NameColum},…
-
Count two different combinations of criteria.
This formula works for one combination of "HWMP" + "Notice Package Approval" =COUNTIFS({Regulations Development Range 5}, CONTAINS("Notice Package Approval", @cell), {Regulations Development Range 3}, "HWMP") I'm trying to expand it to count two combinations: "HWMP" + "Notice Package Approval" "HWMP" + "Pre-Comment Period…
-
formula remove text /keep text in (...)
Hi Experts, I would like to keep only the text which is in brackets below. [clear onix/ftwr white/solar yellow (FY6226), orbit indigo/ftwr white/tactile blue (FY7852), ftwr white/solar red/iron met. (FY6218), core black/core black/dark grey (FY6222)] Result in the new column should be FY6226, FY7852, FY7852, FY6222 I start…
-
How to populate dropdown value list from another sheet
I have a list of employee information in one smartsheet. In another smartsheet, I'm recording events/things about employees. I'd like to have a dropdown list that have the list of employees names (from the other sheet) that I could use to select which employee this record pertains to. Help? Thanks!
-
Destination sheet 'Project' column to auto populate values in dropdown form from Source sheet
Problem 1: I have Sheet 1, where Projects are tracked with 'Project Name' column and I have Sheet 2 with 'Project Name' column. I would like for Sheet 2 'Project Name' column to reference Sheet 1 'Project Name' values in the form of drop down for user to select. Sheet 2 has a form, in this form, I will be using the Project…
-
Formula for looking at invoice month and assigning quarter
Hi there, Formulas continue to be the one area I just can't wrap my mind around. I have a sheet where I have a column called Invoice Month. The values possible for this column are: 01-Invoiced JAN 2021 02-Invoiced FEB 2021 03-Invoiced MAR 2021 04-Invoiced APR 2021 05-Invoiced MAY 2021 06-Invoiced JUN 2021 07-Invoiced JUL…