-
INCORRECT ARGUMENT SET
Hi, First time poster here. I see there is a great community of users here willing to offer their expertise. I am struggling with a formula and am hoping to get some help. I would like to reference a different sheet to display an average score for a date range (by quarter) for each of our query authors. When using the…
-
Grid View - Default Values
Hi Everyone, thanks as always for your help! I have a quick question on the best way to apply default values when adding a new row to a grid view. The idea is that if someone enters a new task name, then the priority and status column for the task would automatically update to "Medium" and "Not Started" respectively. Then…
-
Column Formula Needed: Days remaining until action resolution is needed.
Column in Main Sheet: Ultimately meaning there are T-X days until resolution action is needed (helper column). I have thrown the ranges that I am wanting to report in to another sheet, for calculating the count for each range/category. Formula isn't working and there is where my struggle lies. Formula: =COUNTIFS({Coding…
-
Formula to return the EARLIEST DATE in an unbroken/consecutive sequence
I am trying to write a formula to return the EARLIEST DATE in a consecutive sequence. If the sequence is broken, I want the formula to return the earliest date that the sequence was re-established. I've included a screenshot of my sheet below. I want the earliest date that "Minimum Requirements Met" was "Yes". If it ever…
-
Using =MAX( to get latest date on Dashboard
HELLO! I am trying to get the very last date on a sheet to display on my dashboard. I am using the MAX function to return the date but I keep getting an error…..I have tried the below =MAX({Target Complete}) ….this returns #INVALID COLUMN VALUE =MAX({Target Complete}:{Target Complete}) ….this returns #UNPARSEABLE…
-
Help Pulling Information
Hi, Very new to using SmartSheet. Can someone help me understand if I can pull information from a Sheet in certain rows only that do not have a unique identifier. I just want it based on the answer from one of the columns. I'd like to pull information from 3 sheets into one based on what is listed in one column and in…
-
Creating a dashboard chart to represent the star symbol feature
Hello! We use the star symbols as a column in our project schedule to show the status of the project. I need to create a chart that shows graphically these statuses but have been running into many issues. To help, I created a column in the schedule that is automatically populated with the number of stars for that row.…
-
Dates and Circular References
I have a list of tasks and a common start date for all tasks. Now, if there is a resource or an engineering dependency , then the subsequent tasks will have to start after the current task ends. I am trying to build this in smartsheets with seven columns ID of the task Name of the task Effort Common Start Date Depends On…
-
Count formula not working with helper column on first sheet, returning all zeros
This is the formula I have =COUNTIFS({Overall Grade}, >=4.5, {Fleet}, "717", {Mod Helper}, "100") On the main sheet, there is a helper column which converts the module number to a set 3 digit number (i.e. 102, 141 helper column will show 100) No matter which return the helper column has, all return zero.
-
Reference or copy a column in one sheet to another sheet automatically
Hi, I am trying to figure out a way to automatically get specific columns in one sheet, into another sheet I was originally looking at using a workflow to copy the rows over, but I only wanted to copy a subset of the columns which doesn't look to be possible. Then I started looking at cross-sheet references, but the posts…