-
Index Match Max Date Formula
I have one table for shipping : And another table for Project Closeout: I would like to write a formula to auto-populate the max ship date for each project.
-
COLUMN AVERAGES WITH EMPTY CELLS
I'm trying to calculate our hospital ward census (COVID!!!), however on some days the column contains an empty cell /no value. I'm using the following formula, but to no avail. Getting an error message. Any help is greatly appreciated! =AVG(COLLECT($Count:$Count, $Count:$Count, ISNUMBER(@cell))) Stay safe.
-
Sum of Totals by area and Date
I am trying to set up a formula that does the following: If in Work Log A, the Plant is X and the date range is between 10-1-2020 and now, what is the total cost of this time range for this sheet? I also want to break down by monthly range: If in Work Log A the plant is X and the date range is between 1-1-2021 and…
-
Validate an email address in a contact list
Hello, We have a situation where we have two employees with the same name, "Test User", and they have the following email addresses: test.user@smartsheet.com test.user2@smartsheet.com (Please notice the "2" in this email.) We use a form to populate our sheet and the form user is required to type(paste) the email address…
-
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…