-
Mode Function
Does anyone know if there is a "Mode" formula yet without using a helper column?
-
Counting Children Rows if marked as Active
Hello, I am trying to list the number of projects (AKA children rows that are marked as "Active" under Active Project/Staff) in the Number of Projects column. The formula I am using where I get #unparseable is =COUNTIF(Children([Active Project/Staff]@row ), CHILDREN([Active Project/Staff]@row = "Active"))
-
SUMIFS Help
I am trying to sum a column with SUMIFs. I have two sets of criteria but am having trouble with the third. I am trying to sum the cost if it matches a project title column, and invoiced quarter column. If the invoice quarter column is blank I want to check if a different column (expected delivery quarter) matches. The…
-
IF FORMULA AND 2 DATE COLUMNS
Hello, I am wanting to capture a date into a current date column if there is a date in the second column. Example: If NEW EXP DATE has a new date, I would like that date to display in the CURRENT EXP DATE column. If there is not a date in the NEW EXP DATE column, then I would like to keep the current date in the CURRENT…
-
I have reached the maximum number of Cross References, is there a way to Index Match an Entire row?
I am working on across a couple sheets where the columns contain all the same info across 7-8 sheets and the individual sheets correspond to different groups of people. I am trying to consolidate all of the info into one sheet that updates with changes to the 7-8 reference sheets. I have been doing index matching for each…
-
Date incrementing column formula works fine except in two cases.
Hi there, I am using a formula to establish future dates (Scheduled Pull-Out Date) based on a starting date (Packaging Date) and adding a number of months according to the 'Time Point' column. The formula seems to work fine until I noticed that two entries (in purple) are not following the rule; they are supposed to add 9…
-
Formula that will track the total number of jobs on the sheet at the end of each month
Hello, I am looking to create a formula that will track the total number of jobs (populated rows) in the sheet at the end of each month. The data outputted based on the formula will be displayed on a line graph widget in order to track the progress of the company by each month. For example, if there are 115 lines at the…
-
Ability to Find & Replace text in Formulas
Hi Team, I am aware that this functionality isn't currently available. But, as someone who works on rows & rows of data every day, replacing values in a formula using the Find & Replace feature is extremely helpful and time-saving. As I type this, I have the daunting task of going back to my sheet on SmartSheets and…
-
Percent for activities 100% completed and for ongoing activities and for not started activities
Can anyone please help me with this How i can get a percent of the activities that are 100% completed, and a percent of the activities that are ongoing and for the not yet started activities. the total of three figures is 100% of the project. I hope that I explained it correctly, and thank you in advance.
-
Using COUNTIFS with CONTAINS as a Criterion
I have a multi select list column in Sheet 1, containing campuses. In sheet two I am trying to get a count of how many times each campus is listed in the campus column in sheet 1. Here is my current formula: =COUNTIFS({Event Campus}, CONTAINS("Cypress", {Event Campus})) The results are always "0" for each campus. Given…