-
Count occurrences of each variable of a multi-dropdown list
Hi, I'm building a lease administration tool to help negotiate some leases. Each row (lease) has several stages (preliminary, negotiating, at lease, executed lease, open). I want to create a dashboard metric to show how many rows are at a particular stage: Preliminary - 5; Negotiating - 3; At Lease - 7, etc... What would I…
-
Date Range Conflict - Vacation Request Sheet
Hello, I've seen quite a few questions for date range overlap, but couldn't find the solution. The closest I found was the one below, but it was referencing another sheet, not the same sheet I believe, and not sure a simple edit to that formula will make it work for me. Form requests will populate new rows of all time off…
-
Stopwatch Count up & pause functionality Widget
I was wondering if anyone has found an effective stopwatch widget that has the ability the pause. The idea would be to include this within a dashboard so that when groups are testing, they can record a certain time when something occurs. Thanks!
-
Can anybody correct my below if condition ? I need that asap
=IF(OR(AND([UI UX LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)",[DEVELOPMENT LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)"), "FILLING"), IF(AND([UI UX LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)", [DEVELOPMENT LEVEL OF EFFORT]10 = "X-SMALL (less than 5 hours)",OR([Priority]10 = "HIGH","MEDIUM")), "QUICK…
-
Starting a New Multi Sheet Tracking System
Before I try to dive into this alone - I thought I'd ask for some recommendations. I manage a team of producers who each have a client pipeline. I need to have each producer track their pipeline list with some basic data (dates, closing agent, status, etc.) - so each producer would have their own sheet assigned. I would…
-
Last 7 days
I am trying to create a formula that will pull data from two columns in the sheet as follows: Sheet columns include intakes by location and a date entered column. I want to create a roll up at the top to show intakes by location in the last 7 days that automatically updates. Here is what I have:…
-
Please Help SUMIF Question with Parents and Children
I'm working on a project sheet with dozens of Parent rows, each with a various amount of Children, ranging from one to over twenty. I have a user inputted column to assign known work hours needed for each Child's job, and am trying to create an independent running total for each Parent/Child group. This will allow me to…
-
Is there a "run now" option that will initiate a Workflow?
If I am setting up a Workflow that depends on a specific action, date, time, etc., and I want to see the results now to correct any missteps, is there a "run now" option that will initiate the workflow? I'm trying to avoid having to set the Workflow with a temprary trigger, watch the outcome, and if it works, go back and…
-
Formulas Not Pulling
We currently utilize a very large global onboarding smartsheet. When a new hire accepts a position, the onboarding team uses a form to manually add them to the tracker so we can assign out the onboarding tasks and track progress. As part of a business initiative, we also have hidden column to track the amount of time spent…
-
Maintaining multiple sheets with the same format
I created a tracker that I then created 20 copies of and each one is used by a different team. The sheets all have the same workflows/conditional formatting. The business owner keeps wanting to make tweaks to the sheet (like to add a column or something) and it is very time consuming to do that to each individual sheet. Is…