-
Current user + formula in Contact List?
I'm trying to auto-assign an owner to a task based on the task type: The Owner column is a Contact List Column and the email addresses specified in the formula are associated with current user accounts (one being myself). But when I use a Current User filter, nothing shows! I can only assume that using a formula to fill a…
-
Formula help to return differnt conditions
Hi I am after help in developing a formula to look for certain conditions. I require the highlighted cell in blue perimeter to record certain condition if a condition is true from the 5 cells below. If all cells return Completed then return "Completed" If all cells return Not Started, then Return "Not Started" If all cells…
-
Stacked Bar Chart
I am attempting to create a bar chart widget that summaries hours by department on a given project, but I can't seem to figure out how to get it to display the information I need it to. I have the data set up in a sheet as follows: I would like the graph to show each department's hours as a portion/percentage of the total…
-
Counting using child rows
I have sheet with several parents and children Day 1(Rows 1-20) Time A (rows 3-5) Time B (Rows 7-9) Time C (Rows 11-20) Day 2 (rows 21-48) Time A (rows 22-27) ETC ETC Rows could be added to any of the time slots at any time. I want to keep a real time count of how many are in each time slot If I want a count t of "Day 1…
-
Removing rows based on a value
I've created an onboarding training template for new hires at my company using the following (https://app.smartsheet.com/b/publish?EQBCT=2a335ca126274786adde88923187b3ca). I've removed some of the original reporting features and added our own. I need to create a version of this that can automatically remove, and re-number…
-
Automation - Update Requests
Hi - I submitted this as a question a while back, and thought it resolved itself, but the problem is still persisting. I have an automated workflow setup whereby when someone submits a Form, they receive an Update Request. The Problem The Update Requests are being sent out, according to SS, but people are not receiving…
-
COUNTIFS from multi-select drop down
Hi Community, hope you are well! I would really appreciate some help with the following formula. In a master metric sheet I would like to count multiple criteria. I am using this formula which works great since it is automated once the @row are filled in by my Team: =COUNTIFS({Planning sheet Range 2}, PA@row, {Planning…
-
COUNTIFS
I know this should be easy but I just can't get it right. Trying to count instances of 2 different values in the same column. There are 6 options within the dropdown in the column but I only want to capture the amount of 2 specific values, "Seller Rep" and "Fee" Tried every variation I can imagine of this:…
-
Using Index/Match with Two Values in Another Sheet
In Sheet 1, I like the prices for services for different vendors: Vendor 1 | Category 1 Service | $10 Vendor 1 | Category 2 Service | $20 Vendor 1 | Category 3 Service | $50 Vendor 2 | Category 1 Service | $70 Vendor 2 | Category 2 Service | $90 Vendor 3 | Category 1 Service | $30 Vendor 3 | Category 2 Service | $60 In…
-
Date Range Formula Help
Can someone please help me to create a formula that returns the number of items with a "Permit Expiration Date" between 7/1/20 and 7/31/20 AND has the "360 Photos Have Been Submitted" unchecked? I've tried several "if and" formulas and they didn't work :( Thank you!!