-
How to Count number of boxes checked in a date range, Cross sheet formula
I am needing help with a cross-sheet formula to count the number of boxes checked if the date column is between a certain range. My current formula looks like this: =IFERROR(COUNTIFS({Checkbox column}, =1, AND({Date column}@cell >= DATE(2022, 9, 1), @cell <= DATE(2022, 12, 6))), "") however I only get a blank entry or an…
-
AVERAGEIF returning unexpected value for a % column
I'm trying to create a sheet summary of Progress % for independent rows that are related to each other-- The average % should be 67% when, but the sheet summary formula (below) returns 0% =AVERAGEIF([Progress %]:[Progress %], [Strategic Initiative]:[Strategic Initiative] = "1. Drive growth by delivering prioritized…
-
COUNTIFs Help.
Hello, I am trying to count how many times the names appear in the "Career Counselor" column, these are just a few examples, we have a few hundred different names and thought a formula would be easier. I have tried different formulas combinations using "COUNTIFs" without any success, please help. Thank you!…
-
Automation trigger - copy row to one of several sheets based on cell value
I have a form linked to the new request sheet. Based on the request type I want the row to be copied and placed in a sheet which corresponds with the request type. There are ten different request types and ten different sheets. For example there is a request type for Rotation, New Hire, etc. Then there are sheets named…
-
Multiple IF statements in a column formula
Hi, I’m new to Smartsheet and I trying to write a multiple IF statements that populate the cells in the column with a specific date depending on the value of the corresponding cell in a different column. For example, a column named “Target date value” will be updated to 12/31/2022 if “target date” column has the value…
-
Find next milestone in project plan
I have a project plan in which I want to write a formula to retrieve the next milestone, a task with a duration of zero, from a list of tasks. Task Name = Text/Number column Duration = Duration type column Start = Date column I have this formula which returns the first milestone in the Task Name list. The first task with a…
-
Does NOT contain formula
Hi everyone. I am trying to come up with a formula that provides a solution to this: Column "Product" contains a multiselect dropdown with X, Y and Z as options. Colum "Type" contains a dropdown list with multiple selections available, but needs to reflect "N/A" IF "Product" column as any combination of selections that…
-
Retain Date format when pulling data from another cell
I have one column [End Week Date] that uses a formula to provide the Monday Date of the week a task is supposed to end. This formula works. I updated the [End Week Date] date format to YYYY-MM-DD. My issue: I have another column [End Date Week Text] that I use the formula: ="Ending Week Of " + [End Week Date]@row Expected…
-
Anyone else experiencing formulas for the RYG column randomly going haywire?
I notice the project summaries on a couple of my landing pages went sideways. It appears the RYG column to the left is the culprit. What happens is my R, Y, G, GR columns out to the right will appear as INVALID as opposed to populating the totals. After some troubleshooting I realized the only thing that works to correct…
-
Pull In Managers Manager (rows are not using hierarchy)
Hello, Community! I could use some help with a formula. If Worker or Manager were using hierarchy, it seems like it would be more straightforward. So, what I'm trying to accomplish is a formula to pull in the Managers' Manager. In the below example, the person in Manager is the VP, the name in Worker is under him (so 01…
