Hi all. I tried searching but it is always about how to actually phrase it to get a result so if this has been asked before I appologize. Here is my situation. I have products sold across multiple platforms and the report comes out in excel. I want to put it into SmartSheet so that I can create a report. I know a COUNTIF…
Good afternoon! I love that we can schedule reports to send as a pdf or excel to others an a specific date or schedule. Is it possible to automate sending a report when a criteria is met instead of a date? For example when a box is checked or a field is no longer blank? Thanks in advance for any thoughts or help!
Good morning! I have a monthly report that is autogenerated and sent out so that I don't have to go in and touch it. I love this feature, but I can only figure out a static name for the report. As the report is generated monthly I would like to be bale to identify it in the name of the report or the at least the subject…
Good afternoon. I am trying to combine information from a single row but multiple cells into a single cell on a report. I need this information to show as a list on the report. So for example my spread sheet has: I used a simple formula (=[Item 1]@row + " " + [Color 1]@row + "," + [Item 2]@row + " " + [Color 2]@row + "," +…
I would like to be able to pull data into a helper/report sheet (H/R) from an original sheet (OS) that follows this criteria On the report or helper sheet it would be pulling data from a specific cell on a specific row into a column....so...example becomes
Hi everyone. I am trying to come up with a formula that provides a solution to this: Column "Product" contains a multiselect dropdown with X, Y and Z as options. Colum "Type" contains a dropdown list with multiple selections available, but needs to reflect "N/A" IF "Product" column as any combination of selections that…
I am trying to find a way to generate an invoice from my smartsheet without downloading an "invoice template" as we have a specific invoice format my company uses. I would like to be able to do it from a single sheet, or is there a way to generate a report that will transpose paste the information similar to what you can…
I have a series of columns based on job functions. Only one of the cells will have information and the rest will be blank. I am looking for a formula that will look at these cells and only return the information in the cell that has information in it. This will be combined with the information in two other cells to form a…
I want to be able to update the status of a parent row based on the status of the child row. Currently I have dropdowns set up for "Active", "Inactive" and "Pending". I am hoping to find a formula that when I select "Active" for ANY of the children under that parent it changes the status to Active. Otherwise if ALL…
