-
Record a date for previous check box
I want to record a date for when the check box is true. I know I can set up and automation but I want to see the dates of previous check box.
-
Help with Summary report build using matching dates to sum meeting minutes used.
Good morning! I am trying to build a meeting report for my team's weekly Work In Progress (WIP) meeting. I am using a form for team members to fill out how much time they need for our one hour meeting and on which date. I have a formula that takes any matching [WIP Dates] and sums their [Time needed in minutes] The Sum of…
-
Is there a way to have completed tasks within a sheet, move to a parent row called "complete"
I am trying to see if there is a way to move completed tasks within a sheet so that they are not in the way. Maybe having them move to a parent row that is collapsed called "complete" so that they have open it up to view the tasks, but they are still out of the way. I would like for this to be automatic. Thank you!
-
Sequence numbering based on another Cells info.
I'm looking for a formula to sequence document numbers based on another cells info. I've set up IF functions to code each main column (in blue) which will be hidden in the background & locked to which i then used a JOIN function to get a serial code. (shown in "document Code"). With those in place, On "Document No." Column…
-
finding average risk score
Hello, I am trying to find the average risk score across multiple sheets given the criteria of being a risk and being open. I am trying to use an (AVG(COLLECT( but I am getting an invalid operation. Here is what I am trying: =AVG((COLLECT({CA Risk Score}, {CA ROI Option}, "Risk", {CA Risk Status}, "Open") + COLLECT({CRV…
-
How do I create a function formula for my query?
I want to create a query that sources another datasheet that contains multiple certification types, certification numbers, roles, and ID data where you can type in the employee's name and all of the information will populate on the Query sheet. What function formula would work best with this?
-
COUNTIF is a reference to another sheet or is a link
I need help to count if a cell contains any link or any reference to another smartsheet. Not a specific file, but any file. Thanks!
-
Assistance with Averageif formula
Hello, The formula below was working great until I was asked to add a new requirment where I need to exclude values that are greater than 14 . Otherwise the average is incorrect if greater then 14 "cells" are included. I tried the Averageifs but got lost trying to figure it out so here is my original formulas sans the new…
-
How can I write a formula to pull data based on dynamic columns?
Hi all, I'm trying to write a formula that will pull row information based on dynamic Columns. My goal is to understand the difference in hours worked between last week and the week before. I would like to be able to flag if a Person has not updated hours in a week. I have a 'raw data' sheet which has team member names in…
-
Formula to compare 2 cells and generate the difference on a 3rd cell
Hello all, I am working on a trainings tracker for our project team, and I am a bit stuck. I need to generate a formula that will compare the trainings that are listed in the Required and Completed column cells, and generate the difference on the Outstanding column. Any suggestions would be greatly appreciated!