-
Formula to calculate End Date and Time based on Start Date, Time and Task duration
Hello, I'm looking for a formula to calculate the End Date and Time (MM/DD/YYYY)( HH:MM AM/PM) based on the Start Date and Start Time entered on a form using the Task standard routing time.
-
Formula to add additional year or years to a date referencing another column in the Grid
We have about 17 different training activities that we track for each employee. Upon completion of the training we enter the certification date for that type of training. Most of these certification expire after1 year, 3 years, or never (one time certification). I'd like to be able to use a formula to add either 1 year, 3…
-
why can I not edit formulas on my tablet even though my samsung tablet is in desktop mode?
I want to be able to access and work from my tablet with smartsheet... However a lot of my work includes formulas & metrics ... I cannot seem to create formulas when using my tablet even when my tablet is in desktop mode and going through the smartsheet web version... This really lets smartsheet down :(
-
How do I count the number of times a "Staff Person" selected a dropdown option?
In my original sheet there is a form staff can fill out to request passes. I'd like to count the number of time each staff person requested a pass and what pass they requested. In my metrics sheet the "Staff Name" column has all the names and the other columns would hopefully be where number of "Parking Pass"es the staff…
-
Workdays Counter
Looking for help with the below formula. It countdowns the workdays from the start of the promotion to the completion date. The problem is once it goes past the completion date it starts counting backward. I would like it to stop counting once the completion date is hit. Thank you for any assistance.
-
How to list values in a cell based on another cell with distinct names (in a list format too)
Hi, We are trying to present the labor hours workers have dedicated to one same task on different instances. We started by nesting =JOIN(DISTINCT(COLLECT({Worker}, {Task}, "DC6-" + [Task Label]@row), ", "), ", ") We have successfully filtered a list of workers that have dedicated hours to a task. We would then want to…
-
Formula to convert date (e.g., 03/13/22) to text/number field (03/13/22) in same sheet?
A sheet that has a Dynamic View includes a date field (Start Date) that Dynamic Viewers need to use as a filter. Since users cannot filter by date fields in Dynamic View, I've added a helper column (text/number) in the sheet but cannot find a formula to pull the dates in the Start Date column into the helper column so…
-
I want a formula that specifies the lowest child of an ancestor, parent, child hierarchy.
I am using the Hierarchy formula, =COUNT(ANCESTORS()), to label my project tasks. A lot of the child tasks have tasks below that, going to a hierarchy of 5. I want to create metrics sheet that shows the estimated completion date for the lowest level child. Because the levels vary by task, I cannot choose a specific…
-
Average if multiple criteria
I am looking to see if there is a way to have multiple average ifs to show a visual for the current working project So IF status = working, and assigned to Group 4, I am looking to show average # of days: 1.) Submitted to triage 2.) Triage to start 3.) Start to Root cause 4.) Root cause to council approval 5.) Council…
-
Median & Sum of Multiple Columns in Date Range
Hello, I am attempting to write a formula to display the median of 6 columns, only if they contain data within the last 7 days per the date column. I also need to display the sum of the same 6 columns if they contain data within the last 7 days per the date column. I've tried what seems to be an endless variety of formulas…
