I have the following columns and need to return the value of something from a date through the end of the year. 

1. Est Mo Contract Count - A number

2. Ave admin - Dollar Amount

3. Estimated Value - 1 x 2 

4. Start Date - Start Date that 1 actually goes into effect

5. Weighted Value - Sum of 4


Dear Expert,

I have 40 sheets containing following column with example (example for one sheet only):

Equipment ID | Equipment Group | Part Name | Quantity | Unit Price | Total Price

11MBX21       | AAF                       | Bearing     |  2            |   150        |  300

11MBX22       | AAF


Hello all,

I have been pouring through excel and smartsheet help forums for a couple of days now, and I haven't seen my issue asked or addressed so thought I'd ask here. 

I have, in one column called Terms, cells that contains lists of terms and phrases.  For example, one cell contains the following


Hi Everyone!

I would like to know if you are able to use date columns when automating a progress bar.  Basically dates are entered as product moves to a new stage in the process. As the dates fill in, the progress bar fills as well. I've used nested IF formulas for automating a progress bar but, for


Hi all, I have been trying to figure it out alone but I thought I'd engage the community to see if anyone can help!  I have a column in my spreadsheet that contains phrases separated by commas - for example (though with different words), in one cell it says "Phone, computer, mouse, cell phone, water