-
Hierarchy Drill Through Solutions?
I feed my sheets into Power BI (pre-formatted gantts) and I need to create a way to drill down through levels of a sheet's hierarchy. Ideally, at least 4 levels of the hierarchy, Great Grand Parent, Grand Parent, Parent, Child, if you will. I'd like to mimic the concept that's in MS Project, on the View tab, Data group,…
-
Need help combining IF, AND/OR formulas
Hey yall! I am trying to write a formula that will read the 'Check In' column and "Last Wk Check In' column and check the '2 Wk - No Check In' flag if the following cases occur: If both columns read 'No Check In' (that flag is currently working as can be seen in the screenshot below) If the columns both read "No Data', I…
-
Counting the number of occurrences that meet my criteria
Hello, I need to count the number of approvals received on the created date, on the day after the created date and on anything after that. Here's my formula that's not working: =COUNTIFS({VP of Sales Status Approval}, "approved", {Created Date}, ={VP of Sales Status Date}) Any help will be much appreciated. Thanks!
-
Is it possible to match multiple values with in a single cell?
I'm sorry if this is long winded. I am creating a workflow process where a file will need to be emailed to multiple users at different locations. There is a drop down that lists the locations, in this example it's 3 separate locations, Portland, Minnesota, and Houston. I'd like to keep this drop down to allow multiple…
-
IF 30 days past Planned end date show red
I am trying to create a formula that looks at Planned End Date and determines the following: If <= Today then Green IF 1 day past planned end date then Yellow IF 30 days past end date then Red =IF([PLANNED END DATE]@row(30), "Red", IF([PLANNED END DATE]@row(1), "Yellow", IF([PLANNED END DATE]@row=TODAY) Can I do this…
-
How to add new rows to category in smartsheet via form?
Hello, i need a form through which new products will be added. How to put them in the right category? For example, a checkbox where they offer to choose a category, and which one you choose, the line goes to that one.
-
Conditionally Format Multiple Selections?
Hello, I have a column that allows for multiple check boxes. Is there a way to make conditional formatting prioritize a selection? For example: If I have low, medium, high as options I can make it color code green, yellow, red. But if I have low - me, low - you. low - them, medium - me, medium - you, medium - them, high -…
-
COUNTIFS: Column Formula pulling from 2 Columns on 2 Sheets
Hello! I've built some COUNTIFS in the past and I've always struggled, but I've also always managed to get it in the end. I'm trying to build a column formula that pulls data from 4 different columns between two different sheets. What I've come up with so far is coming back with UNPARSEABLE. =COUNTIFS({Reviewer 1},…
-
COUNTIFS Formula with Multiple Criteria
Hi, I'm trying to figure out a formula to count volunteer hours (Monthly Meeting Hours) by a certain location (Organization Location, "Fairmont Area") for specified timeframe (Quarter, "Qtr 1"). I can get it to work without adding the hours in my dashboard but when I try to add hours get a error . Can you help?…
-
Retrieving one specific text/number
Hi, I'm looking to retrieve a specific text i.e. first warranty, second warrant, third warranty, initial order, labor only. I'm using a countifs formula but I need to count any line which only has the word "warranty" in it. Would I have to use a FIND formula? Thanks
