-
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!
-
Formula across multi Workspaces
I am trying to create a formula that encompasses many different areas across numerous workspaces. I need to be able to calculate the percentage of complete tasks within a milestone across 6 different workspaces. I know I am missing a key element to allow the formula to work but after playing around for 2 days I still can't…
-
Formula based on criteria?
I have no idea if this is possible, it seems like it should be. I want to calculate the difference between two cells, but only when both cells have values, otherwise the cell should remain blank. So if "January Spending" has a value (Cell B), then it should be subtracted from the "Estimated Monthly Spending" (Cell A) -…
