-
One Approval for Multiple Lines/Whole Sheet
Hi everyone, I have stuck with this problem for a while and seen many questions about how to consolidate the approval requests to be sent in one email. It seems like the only solution so far is to create a report with a approval column that has checkboxes for approve, deny, etc. My concern with this way is that, in case…
-
COUNTIF with multiple select dropdown column
Hi, This has me going mad! 🤬🤣 I have a sheet reference "Business Area" which has a column type of dropdown multi-select. I'm then using a COUNTIF on specific values to compile a metric sheet. This is counting fine where the dropdown has "C" and "E" selected: =COUNTIF({Business Area}, @cell = "C" + CHAR(10) + "E") However,…
-
Data Migration/ Data Shuttle between 2 sheets
I have 2 sheets Sheet 1: Projects pending approval Sheet 2: All the projects that have been approved I want to build functionality where when I check an approved box in Sheet 1, it will automatically push to Sheet 2. There are a couple issues/ complexities. One of the biggest issue is that the Sheets have different column…
-
Summary reporting with conditional formatting
Hello! I'm trying to build out a way to dynamically report on 58 state/territory sheets. Ideally, this report would have the total number of rows in the state sheet, plus the number of rows that meet two separate sets of conditions, with conditional formatting applied. I've tried doing this two ways: By using a sheet with…
-
Link to another sheet and conditionally output
Hello, I have one sheet that I am trying to link to and output data conditionally. There is a "LineItem to WPID" sheet where I am trying to bring in the WPIDs from my "WPID Matrix" where the LineItem header matches with the LineItem record if the Department is "CF". Is there a function I can use to bring in this data? See…
-
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},…
-
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!
-
Parents Misrepresenting Start & Finish Dates of Children
I have the Parent Rollup Functionality turned on as it is essential for my project to handle to dependencies. The problem I'm trying to overcome is that the Parent displays Target Start (TS) and Target Finish (TF) dates when not all children are populated in the same fields. If child#1 (of 2) has TS and TF dates populated,…
-
I need to determine if a date column is blank then it returns a message
Hello, I want help with a formula to return a message that says met goal if the date is blank or did not meet if the date is populated. I tried this formula but it is not working it returns #Unparseable =IF(ISDATE([Request Intake Range 9]1:[Request Intake Range 9]22), "met goal", "did not meet") So essentially I want to…