-
Time calculations with data collected by a form
I am using a form to collect data that includes a unique ID for each user. The user will check in by completing the form with their ID and "Arriving". When the user is done, the user completes the form again and selects "Leaving". I now have two rows of data where I extract the time in and time out from the creation…
-
INDEX(COLLECT) function problem?
I am using an INDEX(COLLECT) function to return an amended date by family name. It works well except in the event a family was amended twice. It is returning the first amended value as opposed to the latest amended value. How can I get Smith to show up as Aug-27-2021 in Column 5? When I change row index to 2 it works for…
-
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!