-
Adding total project hours
Sorry hit send too fast! Is there a way for Smartsheet to add up hours that change weekly? In my example below the row represents 1 active project. The Weekly Hours changes each week and is updated via Datamesh from another file. I was wondering if there was a formula that allows me to have hours total up each week in the…
-
How to calculate actual % and Planned %: Comparing with columns, start date, end date, baseline star
How to calculate actual % and Planned % : Comparing with columns { Start date, End date, Baseline start, Baseline End date }
-
How to extract numbers from a cell when the position and length of the numbers are always different
I've tried splitting text with numbers in a string in a single cell but can't find a working formula. An Item number is always available in a Item/Document Name string, but only the article Number should be copied into a separate column. The position and the amount of the number is variable. The only factor separating them…
-
Use countifs to count all projects with a quarter date and year from a date column
my current formula is =countifs({sheet reference}, ROUNDUP(MONTH(@cell)/3) = "4", {sheet reference}, Year(@cell) = "2022" I have ensured the column from the reference is a date column, however I am given invalid data type as an error
-
Using the =Left feature and then vlookup off of that result from the left
I am using the left feature to extract 6 numbers from a field. It will always be 6 character numerical figure all which are on a separate smartsheet. I am getting a no match when trying to do a vlookup off of this left. The number that I am trying to return is a $ figure all which are on the separate smartsheet. I've asked…
-
Count If Formula
Hi there, I am trying to look up a WBS number from a cell in a column and count the number of times it appears in another column with the status of either "blocked", "work in progress" or "Not Started" The first criteria seems to work (i.e. the bit that counts the blocked", "work in progress" or "Not Started"), but the…
-
How do I implement conditional drop down in smartsheet
I have a Sheet 1 where a user can add a customer and multiple addresses for that customer, Column 1 'Customer Name' and Column 2 'Address'. In Sheet 2 I have a form where a user can select the 'Customer Name' (from Sheet 1) and the 'Address' (from sheet 1). I would like the address options in the form(Sheet 2) to be…
-
VLOOKUP with numerous arguments
Hello! I am trying to automate a status column but with look ups on two sheets. I have started the formula but I am wondering if it is possible to do this many arguments in one formula? Has anyone had any success at doing similar? Blank = Assembly Job assigned to (is blank) sheet 1 Not Started = Assembly Job assigned to…
-
Networkdays, Error?
I'm running =NETWORKDAYS([Date Submitted]22, (TODAY())) which counts how long a design request has been in the Dept. In some cases the count is correct, based on today as 19th May 2020, yet in other cells it's out by a day or more? I've confirmed the formula is the same in the column. Help?
-
SUMIF children using a drop down column
I want to use SUMIF, to sum up, a specified amount of money based on a drop-down column. I would like this to dynamically change the total amount shown depending on the chosen drop-down option. Is this possible? This is a formula I tried but the logic of course isn't there: =SUMIF(CHILDREN([Report Row]:[Report Row]),…
