-
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) -…
-
Help with reporting between 2 dates
Hi, I am having issues with working out how to get a total count on dates 1st to count how many of those tasks were updated under 7 days. =COUNTIFS({person1}, [Person1]@row, {Date updated}, <=TODAY(7)) 2nd to count how many where done between 7 days and under 14 day =COUNTIFS({Person1}, [Person1]@row, {Date updated},…
-
Change Text/Number to valid date
I'm using a date in the primary column, of course Smartsheet sees this as just text/number. I've added a column called "Date" and want to convert the Text/Number to an actual date. Primary Column...........Date 1/29/2024....................01/29/24
-
Question on Metric Sheets and COUNTIFS formula
Hello! I was working on a metric sheet and it was working perfectly but then all of a sudden my whole table went into error - not sure what I did! Here is my formula: =COUNTIFS({DPM Programme FY24 Workstream}, [Primary Column]@row, {DPM Programme FY24 Status}, [Column2]$2) And here is my table:
-
SUMIF Formula for Multiple Criteria from Multiple Sheets
I want a tally of the results in {Master-# of Assets} and {VisionHub- # of Assets} from two different sheets (that are almost identical in columns) I want a formula that will give me this tally across both sheets with the condition that the Team Managing is in the Primary Column and the FY is in the [Primary Column]$2…
-
Total of Certain Value Across Multiple Sheets
Hello! Hoping someone here can help. I have 6 sheets that are identical in setup and parent rows (inventory for each vendor - Child rows are only varience being actual inventory). I'm needing a summary sheet that totals the quantity across each of the 6 vendor sheets. I've tried a variety of…
