-
Automation for Updating Metrics Data on Dashboard
I have data that rolls up into a Metrics sheet. I currently have metrics, by month, displaying on my dashboard The data is currently manually update, by month. Is there a way to automate the change in month, subsequently updating the data displayed, i.e. volumes?
-
carrying forward unfinished task to next sprint
Hi there, Once I complete a sprint and I need to start a new one; how can I carry forward ongoing tasks to the following sprint? Thanks !
-
filters and burndown chart
Hey there, quick questions: Can I apply multiple filters in the card view section (e.g. I need to filter by person, sprint and epic/project) Is there a burndown chart report to analyse the team’s productivity? Thanks for the help!
-
Store past sprints in card module
Hi there! Once I complete tasks and a 2-weeks sprint, how can I store them as completed or hide them, so I don’t need to see it in the Kanban/card board, but I can still search for it if needed? Thanks!
-
It then Question returning a date response
Hi There, I am at a beginner level and want to automatically return a date result in a whole column. I think the formula should look something like this but it isnt quite working yet.... =if([Validation update request Completed]@row}ISBLANK([Lead Validation Date]@row,blank,date) The Validation update request completed…
-
How do I make the numeric value returned in this formula usable in other mathematical formulas?
Value returns correctly, but I need to be able to add that value to OTHER formulas and fields. =IF([Target Level:]@row = "Standard", "$19,000", IF([Target Level:]@row = "Superior", "$100,000", IF([Target Level:]@row = "Premier", "$240,000", IF([Target Level:]@row = "Elite", "$490,000", IF([Target Level:]@row = "Platinum",…
-
SUMIF or SUM for cross-sheet formula
This discussion was created from comments split from: SUMIF - Referencing another sheet.
-
Index Collect Contains Formula
Hi, I'm trying to report data in one cell if data in another cells contains a partial phrase listed in a third cell. Here's what I've got: =INDEX(COLLECT({WE Org Owner}, {Pilot/PM}, CONTAINS([Primary Column]@row, @cell))) It's giving me #incorrect argument. The reason I need a Contains is because the primary column is…
-
countifs issues
=COUNTIFS({Incident Summary Form Range 1}, "Sioux City", {Division}, "utility", {Incident Summary Form Range 8}, AND(@cell >= DATE(2021, 1, 1), @cell <= DATE(2021, 1, 31))) This worked until i added {Division}, "utility", can someone tell me what i did
-
combined Countif and weekday function
I have a sheet which has a date field. This field is filled in with a date based on the date to which something occurred. I have helping columns in that same sheet that extracts only the Month, Date, and weekday based on date field. With the "helping columns" on a different sheet which i'm calling "stat sheet" i'm counting…