-
Row copying over twice after updating columns
Hello :) Our Archive Metrics sheet tracks the number of units we receive, wash, process, etc. daily. For the last 2 years we have only been dealing with towable units. We recently brought in motorized units and I updated columns on the sheet to reflect only towable units and added columns to reflect only motorized. Here's…
-
automation for adding date?
So I'm fully aware of the automation to add a date when a cell is changed, but it doesn't seem to be working for me. Hoping someone might point out where I went wrong. I have a grid of teams and members where I keep track of which members are complete, I'm trying to track when a 70% or more of the team is "done". I've made…
-
Formula that counts based on two different columns
Hi there, I feel as if this has been asked before, but I wasn't able to find a formula that fit my sheet. I'm looking to have a column that simply places a "1" if two conditions are met in two other columns. So basically: =COUNTIFS( [Column A = 100] AND [Column B =100] then place a 1. There are a few other criteria's that…
-
Auto filling a cell based on the entry in another cell
Hi, We have created a form to capture feedback from several stores we manage. How can i get the Store managers name to auto populate on my sheet based on the store name? I dont want this on the form just on my sheet when the entry has been submitted. Sorry i am really struggling with this and fear it is around Vlook up…
-
AVG (days until client) and if
Dear Smartsheet Community, I wonder how I can fix this issue: I want to show in my dashboard the average number of days until a lead becomes a customer. So far, so easy. But I only need the cases above zero days Would it be =AVG(Collect[interested since]; >zero P.S. I cannot put the 2 brackets behind the above formula.
-
index match quandary
I'm using this formula to return a student specific date from another sheet based on a student code =INDEX({Student Code from info sheet}, [Student Code]@row, {IEP date from info Sheet}) it says #INVALID DATA TYPE I've used this INDEX MATCH and this type of formula before and I'm not sure why its not working
-
Formula to check the Unit availability
I would like to check the Unit availability, we want to check the start date & end date and U1, U2, U3, etc. and unit availability column should provide whether it's available/nonavailable to use for other projects Is there any formula that can do this? Also when a unit is assigned for a particular project for a particular…
-
Select Multiple Options
Hello, I built a scheduling tool that contains several countries that are organized into regions. You can choose one or multiple countries in a form to schedule an event. I'm trying to make it so that if I choose to schedule an event for an entire region or in all regions, the user doesn't have to select each country…
-
Sumproduct for Ranking
I have a formula in excel which evaluates a range of cells then provides a ranking without skipping numbers (1, 2, 3...etc.) Additionally, duplicate values are assigned the same rank, I need this. I've tried playing around with the RANKEQ formula but some rank numbers are being skipped. Excel Formula:…
-
How to automate a new project to the Project Plan?
Hey team just wondering if anyone can help me out.. I am using the project management template and am trying to work out how once ive put a new project into the Project intake sheet I can then get it to automate into the Project Plan?
