Hi there I need a formula that will look across rows and columns in a table. For example, I need the result for School District-B with 23 items. The result from the table below should populate with: $350 1-5 6-15 16-25 26-50 51-100 100-50000 School District-A $100 $200 $300 $400 $500 $600 School District-B $150 $250 $350…
Would be awesome to be able to see projects in a format like that used by Casual.pm. Gantt charts make it very easy to see how tasks lead to deadlines, and to identify critical paths, but they are not great at immediately showing how tasks depend on one another, nor the total number of processes in action at any given…
Hello, We use the form function for all of our production orders everyday and recently, the form has been flip flopping between two different layouts. One is where there is the capability to upload multiple documents at a time and one where you cannot. Is Smartsheet doing some sort of testing or updates? Appreciate any…
I would like to submit a Smartsheet feature request that will allow users to do a "Multiselect" for a Column type of "Dropdown list". At the moment the only way I can do something similar is to create multiple checkbox columns, which makes the sheet hard to use due to all the extra columns. In Smartsheet today, you can…
Hello Community, I am looking for some help with an email IF Statement and a formula to more information, when a match is detected. I have a couple sets of 3 columns each: Email, First, Last and I need to compare Email with other sets of Emails. NOTE: The 2nd or 3rd or 4th set of Email, First, Last will not have First and…
I have a formula pulling info from another sheet. This then feeds into a dashboard metric. The formula is a COUNTIF for anything with today's date. What is happening (and this sounds crazy....I had to get a couple of people to observe it to confirm it wasn't just me) is that at some moments in time the figure on the…
Hi, i'm looking for someone who can help out in setting up smartsheet for the company.
Hello - I have setup a sales pipeline spreadsheet and a separate proposal tracking spreadsheet. I would like to create a automatic workflow in the sales pipeline sheet so that when "Proposal" or "Pitch" is selected as a status in the pipeline a automatic workflow takes place to present the form for the proposal tracking…
Dear all, Our current receivable has many terms such as advance payments / 30-45-60-120 days deferred. We are maintaining it in an excel sheet but I am afraid some receivable might be missed. What I am looking for is a sheet where I enter the customer invoice value and by when what percentage of that value will I receive.…
