-
How do I populate the highest parent level data into another cell?
I'm using the '=PARENT([Primary Column]@row)' formula, but it's populating data from the parent row, even if the parent row is a child of another parent. I need to populate in a separate cell data from the highest level parent row. In the example below, is there a formula that would populate Primary Column row 1 data,…
-
Nested IF/CONTAINS for Multi-Select Column
Hi. I have a multi-select column in which I have the following formula: =IF(CONTAINS(PF@row, {Offer Component Matrix_PFlists ACI}), "ACI", IF(CONTAINS(PF@row, {Offer Component Matrix_PFlists AppD}), "AppDynamics", IF(CONTAINS(PF@row, {Offer Component Matrix_PFlists CCP}), "Cisco Container Platform", IF(CONTAINS(PF@row,…
-
Using NOT HAS with AND in formula
I am trying to capture work done that was assigned to individuals in three different scenarios: Scenario 1) work done by members of a specific team (team members listed on a different sheet, noted as {ID Team Roll Call Sheet Range 1}) Scenario 2) work done by people that are NOT members of this specific ID Team Scenario 3)…
-
#BLOCKED
Has anyone had an issue where a cell with SUMIF changes to #BLOCKED when a cell in the range changes? I have had this periodically happen. I will cut the SUMIF formula and paste it right back into the same cell, which looks to fix the issue until another value changes. Also, it looks like closing and reopening the sheet…
-
Nested If else statements with a hierarchy based on fields containing dates
I have 5 tech levels in my sheet that contain the date in which someone reached that level. I then have a column that needs to display the highest level that contains a date. The Tech level for the first line should show as "Tech 1" as it is the highest level with a date, whereas the second and third rows would show a Tech…
-
Automation help
I would love to use what we have built in Capsule and use them here at Smartsheet. My main question for now is this... Is there a way to automate a start date/due date based on me clicking "done" For example once the Email Clinic for set up call is clicked DONE, I'd like to have a due date of 7 days after it was clicked…
-
Conditional Formatting on Card View
Complete newbie here on SmartSheets, I've watched some tutorials, but seem to be missing something on the the conditional formatting. Basically we have phases for my team to move a deal from one phase to the next. Within each phase we have a due date of when this deal should move to 6. Account Management. What I am trying…
-
How to stop a formula once a date has passed.
I have this formula: =IF([Hidden Team:]@row = "ALBQ", {[Rosters] 2021 CC Team Range 1}) The info my formula is pulling is date sensitive, and the info will change over time. Once a date in the row is reached I do not want the formula to perform anymore. I need to freeze the value that was returned once a date in the row is…
-
SUMIFS & Specific Text/Quarter Requirement
I am trying to write a formula for a dashboard that sums the amount of money we spend a quarter based on a specific text. This is what I have so far and I'm getting "Invalid Operation". =SUMIFS{Log Sheet Range 2}, {Log Sheet Range 1}, CONTAINS("Pens", @cell), AND(({Log Sheet Range 7} = "Q2"))) Log Sheet Range 2 is the…
-
IF OR Formula
Can I get help with this formula? I need the answer to be 4 if either of these two columns are a yes. If both are a no, then I need the answer to be 0. If one is yes and one is no, then the answer still needs to be 4. =IF(OR([Innovate Audit]@row = "Yes", 4), ([Innovate Audit Included in Upgrade?]@row = "Yes", 4), 0)