-
COUNTIF date is within 30 days -- not calculating correctly
In the sheet summary, I am trying to count if the date in the date columns falls within the next 30 days. It's working fine for Date 1 column, but not for Date 2 column (or the copy of date 2 I created to verify). This is my formula: =COUNTIF([Date 2]:[Date 2], <=TODAY(30)) It's calculating a number, I am not getting an…
-
How to Auto-populate dates from Project Deadline
Hi there, I am setting up timeline "project" templates for my team. We have a handful of projects each year and they all will follow this same process so the duration for tasks and logic "predecessors" are already built in. I want to be able to set a deadline in the Baseline Start/Finish column on the project complete row…
-
Modified =SUM(CHILDREN()) Formula needed
Dear All, I am struggling to modify this formula: =SUM(CHILDREN(Points@row)) Working in agile development, my "Points" column contains development points needed to complete a task. Overall I have 4 hierarchy levels: Task, User Story, Epic, Initiative. I would like to display the sum of task points on the User Story line…
-
Vlookup In Form
I have read through some answers and can't find what I am looking for. I want to create a form that when a certain name is selected, it prepopulates the remaining fields BUT allows the option to override meaning it can't be a true vlookup as it locks the field. AND I need this option avaliable within the form prior to…
-
Count If with 3 Criteria
Hi - Trying to count cells that are 1) Active, 2) have Completed - Not Implemented interiors, and 3) Completed exteriors. I thought count if would be best, but I'm receiving an "Incorrect Argument Set" error. Not sure of the best way to set this up... =COUNTIFS({TRACKING SHEET Range 11}, "Completed - Not Implemented",…
-
Status updating based on Schedule Health
Hi All, I'd like the status of a task to update based on the color of the task health. Blue Health = Complete Green Health = On Track Yellow Health = At Risk Red Health = Late I am not sure the formula I should be using. Thanks!
-
Max Formula - related question
Hi I have a table for our Product Development Items. In it I track 3 levels of items: Initiative, Epic, User Story. In a separate column I assign Quarters, e.g. Q1'23, Q2'23, or H1'24 or 2025. For the Parent level I would love to be able to identify which of those is the farthest out quarter. Is this possible? Best, Sylvia…
-
How to calculate 2 condition from 2 different column and link it to another sheet
Hi I would like to calculate my current sheet records with 2 different condition which was "on going" at the same time it is an "Valid Issue" Both "on going" status, and issue type "Valid Issue" is from different column. How do I manage to calculate the on going cases with valid issue only, and I would to calculate them…
-
Newbie - Tracking Item location based on most current date
I am fairly new to Smartsheet's and am struggling to figure out some of the formulas. I am with a volunteer fire department and we are using Smartsheet's to track our equipment and maintenance. I currently have a sheet that tracks when we fill our air cylinders and which station the cylinders are at. Each cylinder which…
-
Automation - Trigger a notification after status has been updated
Hola, Need some help with an automation. I have notifications triggered based on status (Open, Manager Approval, Closed). There is a step that I need to trigger a notification when a status moves from Manager Approval to Open, can this be done? I have a separate notification for when the status is first set to Open. Thank…