Trending in Formulas and Functions
-
CONTAINS FORMULA WITHIN A DATE RANGE
Hello, I'm trying to create a formula to count / sum the number of times a cell contains some txt within a date / year range. The formula works for regular cells which contain only one piece of txt. However I'm trying to count from a cell which has multiple entries. I'm sure this is an easy one. Can anyone help please?…
-
Need help with Index formula across sheets
I have a Master sheet that I would like to source information to subsheets for Project columns, of which then the % complete and date complete on each subsheet gets Indexed back to the Master sheet. However, I am needing to add 2 lines on the Master sheet to populate on all of the subsheets, but when I assign them unique…
-
Adding cells with IFERROR blanks
I'm having an issue with this sheet: Smartsheet - Quote The COST / PC column is where the issue is happening. On line 4, I'm testing out using a different material that doesn't conform exactly to the sheet's setup but I'm trying to build in functionality to make it possible. When the columns being added by COST / PC are…