-
Prior Month Month/Year Formula Crossing Over 2 Years
Looking for some guidance on a formula. I am needing to collect a quick snapshot of Data for the following: Current Month - based on today's month + current year Prior Month - based on the month prior to today's month + year. Given that we are in January, the current month is populating correctly with the formula I…
-
Formula count sum ?
Hi everyone i am looking for a formula. Example: if there is a number in a cell, I want to add the number of the other cell. Example: Cell 1 is the number 2. in cell 2 is the number 3 then the answer should be 5 if i then enter in cel 1 the number 2, the answer should be 7. if I then enter in cell 1 -2 the answer should be…
-
SUMIFS referencing another sheet
Hello, I'm trying to use SUMIFS formulas to create a summary grid based on another grid. =SUMIFS({Counter}, {Submission Date}, @cell = "", {Submission Status}, @cell <> "Waived", {Submission Status}, @cell <> "N/A", {Due in the next}, @cell = "1 Week", {TAT}, @cell = 3) The formula should sum the numbers in the Counter…
-
How to combine duplicate data and sum totals of those rows.
I have a sheet that we track data for on a monthly basis for the same items (example below). I would like to display a "top impressions" and "top clicks" widget on my dashboard, but cannot figure out how to show this data without it being duplicated over the 12 times (once for each month). I know a report will need to be…
-
Summarization Formula Not Working
I'm trying to create a summary that adds the number of households (HH) for projects in a Construction status. Is it my formula or is this not possible in SS?
-
Formula to return a date that a cell was changed to a specific value
I'd like to record a date that someone has changed a cell within the smartsheet to a specific value. The cell tracks 'stages' of a sales operations cycle (Proposal, Commit, Execute). I want to record THE date that someone changes that cell to "Commit". Is there a formula I can use to track those dates in my smartsheet?
-
Count IF as a Column Formula
I have a file that gets updated daily. There is a formula to identify unique items, in this case states. The file also has a formula to look for duplicate part numbers. The issue is that if the last row is a duplicate and the end users deletes the row, then the unique items formula disappears and no longer calculates on…
-
COUNTIFS with HAS two words/phrases in same cell
Hi! I am trying to write a formula to count ONLY when the cell in the description column has BOTH "eat" AND "scale". I want to use HAS because sometimes I want to search for an acronym and I think it is counting other combinations of letters when I use CONTAINS. If the description @ cell has both phrases, I want a 1 to…
-
Trying to determine where we are in the process
I am trying to show the status of a team based on four steps in the process. I have written it as an IF AND statement but can't figure out how to get past the first check. step 1 Department review complete, step 2 internal review complete, step 3 user input complete, step 4 build complete step 5 pick up complete Each step…
-
Help with a Rolling 12 Month Formula
Hello, thank you for taking the time to look at this and I appreciate any assistance anyone out there might be able to supply. I'm trying create a Rolling 12 Month Formula and running into an issue getting it to work. I have multiple programs on a sheet that have metrics and are nested under a blue header row. The data…
