-
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…
-
SUM FORMULA BASED ON MULTIPLE CRITERIA
Help PLEASE!!! I am looking for a formula that will sum the total travel cost of resources, if selected, based on the qty of each resource and also the resource rate (from another data sheet). For this example I have 3 travel items: Line 1: I have 3 resources which will be traveling, project manager, design engineer and a…
-
Formula To Count The Number of Days an Incident Occurred
I am building a safety event submission sheet and I wanted to add some metrics to a dashboard. If an event is submitted, that day is considered a "Red" day and if no events were submitted it is a "Green" day. The goal is to make a chart that shows number of red days out of the month. A day will be considered red regardless…