-
What is wrong with this COUNTIFS formula?
=COUNTIFS({Consumer Alerts Sign-up Form Date}, >=DATE(IF(MONTH(TODAY())>=7, YEAR(TODAY()), YEAR(TODAY())-1), 7, 1), {Consumer Alerts Sign-up Form Date}, <=DATE(IF(MONTH(TODAY())>=7, YEAR(TODAY())+1, YEAR(TODAY())), 7, 31), {Consumer Alerts Sign-up Form Range 1}, @cell = "") I am trying to create a COUNTIFS formula for each…
-
Formula to sum values based on multiple cells.
Hi All, I am managing a material tracking sheet and I need a little bit of help with the following: I need a formula (or some method) to sum values of cells in a column called 'Qty'' based on the info in 3 other columns. So the formula will find all the rows with where the PO No. cells match and the Material Description…
-
Merged: Automation Action to calculate a Variable Value
This discussion has been merged.
-
Find Difference between two Cells that could be Multiselect Dropdowns or Text
I am pretty advanced when it comes to smartsheet and formulas. But this one has me stumped. I am trying to find a way to report on the difference between two text or multiselect cells. Any advice would be much appreciated.
-
Do formulas not work in automation?
I'm trying to make new rows copy the cell in a column under a parent but this doesn't seem to function. Am I missing something? When I run this, it posts '=Parent() which doesn't help me.
-
Remove Formula Error if blank
I am pulling in data from another sheet based on conditions in the sheet. I can't figure out how to hide the formula error if the value from the other sheet is blank. There will be many cells with blank values and a few that have values to pull in and the formula errors overwhelm the sheet. Formula I'm using:…
-
Join Ancestors help
I have a sheet that has a Task Name column which has Parent and Child rows. I have another column "Levels" that tells me the level that each row sits in the hierarchy. My formula does everything except include the data for task names that are at Level 4. I cannot figure out where I am going wrong. Any help is greatly…
-
Metrics Sheet Formula to Calculate Average of Numbers in Column on Main Sheet
Hi, I have a main sheet with the columns seen below. As stated in the notes, I have not accounted for skipping the calculations when a date missing in a row. That's my first request -- correcting the first 3 formulas. Second, I have a metrics sheet where I want to have a formula calculate the average of the numbers in the…
-
Running job to date hours on a project per task code?
How can I have a running total of Job hours to date per task code display on a sheet that shows actual hours vs estimated hours? The problem I am running into is: I have a weekly time sheet that is filled out for the employees on a particular project. The time has to be separated out by Straight Time, Over Time, Double…
-
easier references to other sheets
Hi all, I prefer to use references of the form {sheet_name Range 1} rather than using the "link from cell in other sheet..." because the formula can be copied to another cell where trying to copy the direct-linked cell only copies the value, not the link. If I have a lot of cells all linked to a particular cell in another…
