I'm trying to create a formula that looks up a row and column and pulls in the resulting detail. I've researched through Community and all the various documentation but can't get this to work. =INDEX(…
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.
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 e…
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 table…
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…
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 back…
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), …
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 (t…
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 t…
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 d…
