-
Moving rows/updating cells
I manage a portfolio of projects which I have to report on. I'm a Pro user, so I don't have the functionality that could probably make this task very easy. My project managers are required to use a company solution (not smart sheet to create project plans and updates). I've created a smart sheet that lists all of the…
-
Is it possible to get a count in Sheet Summary with the following equation?
=IF([CFO Install]@row = "yes, me only", 1, IF([CFO Install]@row = "Yes, my spouse and I", 2, IF([CFO Install]@row = "Unable to attend", 0))) I keep getting #unparseable. I tried COUNTIF(s), SUMIF(s) Right now I have been creating a separate column in my sheet with the formula to get the sum. I would like to clean up my…
-
Nested formula with sheet references help
I need a formula that will: look up a name listed on sheet #1 on Sheet #2 and pull the most recent date they completed training. So far I have tried two formula combinations and neither has worked. =IF({Training Data Range 1 - Name} = Name@row, MAX({Training Data Range 2 - Date})) #INVALID OPERATION =VLOOKUP(Name@row,…
-
sum values of a column in another sheet based on the column position
Hi all, Is there any way to sum a certain column in another sheet based on the column position? I think of having a reference like {another sheet range} with a range of e.g. 4 columns. I would like to sum the values of the second column, but do not know how to make this. SUM(INDEX({another sheet range}, 2)) will not work,…
-
Want to Calculate Crew Required Based on Specific Dates
Below is the screenshot of the formula I am trying to use but it always returns 0, Please guide Thanks!
-
Formula for automatically pulling rows of data from one sheet to another using checkbox
Help please 🙏 I need a formula or solution for automatically pulling rows of data from one sheet to another using a checkbox... So sheet A has a ticked checkbox, meaning I need the information from most columns in the ticked rows moving over sheet B every time a sheet A checkbox has been ticked.... (I need name about 5…
-
Formula referencing another worksheet
Hi, I am trying to create a formula to determine how many tickets are in a Category and have a due date within the next 30 days. I am trying to do this outside of the worksheet so when creating my formula I need to reference back to this sheet, however no matter what I try I'm still having the same issues...…
-
Using INDEX/MATCH with images
Hi all, Is it possible to use an INDEX/MATCH formula to bring an image from one sheet into another? If not, anyone recommend a solution/ work around? I am building a new sheet that utilizes INDEX/MATCH to bring in info from several others and I would like to be able to bring in these images from their source document.…
-
Count Between Dates
Hello, I need a formula that identifies how many rows I have per quarter. Example; Q1 from Jan 1st to Mar 31 of this year. Some help Please
-
Cant get a countsif formula with multiple phase helper sections to work.
Hi I am trying to count project health indicators , But only i certain sections of my project plan. I can get a basic countsif formula to work: =COUNTIFS({Project Plan - Health}, =Metadata@row) + 0.0001 I can also get it to work with just one section : =COUNTIFS({Project Plan - Health}, =Metadata@row, {Project Plan - Phase…