I'm trying to calculate the total spend for a customer based on a list of transactions in another sheet in a specific date range. The dates in the sheet I'm trying to reference are classified as dates in the column properties and appear as "1/30/19" for January 30, 2019. 

For example, in the sheet

Hello!

I am trying to set up a process where employees at my company fill out a form, attach an invoice and then I route for approval from my sheet. I need to figure out some sort of way to save both the invoice that was attached along with a copy of the approval that I have being emailed to me. In

I am in need for the status colum 1 (red, yellow, green) to automatically change when column 2 (date) is passed column 3 (date). Can this be done with a formula? 

I can do "=IF([Approved Required Delivered Date]1 < [Adjusted Delivery Date]1, "Red")", however, I am sure on how to add the other two

Hello! I've had a notification set up since March that sends to 2 other people besides me whenever I add or change anything in my Smartsheet. It worked beautifully until July 4th. I've changed nothing, but the notifications stopped sending. The last one any of us received was on July 3rd. Is anyone

I commonly have task lists that are nested to an arbitrary number of levels. In card view, you can filter tasks to level 1, level 2, etc. This isn't very useful to me. I think it would be far more useful to have a filter "include summary tasks (or not)". Since my actual tasks are always on leaf

Hi, I think the graphs implemented last year were an excellent and needed set of features.  I still however have to use PowerBI for some of our charts.  This is problematic.  Can we get Radar Charts into the Graph

In Gantt format - I leave some rows blank to separate workstreams or buckets of work.

But for whatever reason - Smartsheet goes and fills just the start date automatically in these row.

I delete them, and then after I save, they come back again. They are harmless, but misleading and hurt the

Hi everyone,

I've searched through the community but couldn't find the right solution.

I need to feed specific sales metrics into a dashboard but want it to update, according to the Today column. I receive the previous months information on the 15th of each month, so the formula would need to cover

I'm new to smartsheets and am not an excel expert, but I've been building some sheets and workflows and have a question about more advanced capabilities of the program. 

I'm hoping there's a way to automatically track inventory usage based on information input into a separate smartsheet form?  I

Hi, 

I was not able to find a way to import an Excel file that has images embedded in cells, and keep those images when the import in complete. Is that possible? Am I missing something?

Or do I have to re-import those images manually, one-by-one?

Thanks in