-
How do I find a smartsheet expert for hire to help build out our workspace?
I am building out a new workspace for some large marketing intergration projects. I am way over my head with smartsheets, but I have used it to complete amazing M&A sheets. I want to start intetegrating smartsheets into the operating side instead of just the due diligience side of the business.
-
Project Plan with several Tasks in one Line
Hallo! Currently, we have an Excel sheet, which I would like to transfer in Smartsheet. However I cannot find a way to do so, so hopefully someone can help me. As seen in the picture, every row is an own project and every column (except the first with the name of the project) is a certain day, like a Gantt. So on every…
-
Smartsheet Referral Program
Hi, Wanted to check if smartsheet has any referral program (where existing user introduces new users) ? If yes, how does the same work ? Have tried checking the app but unfortunately couldnt find any such information pertaining to referrals there. However there is a Smartsheet Referral Agreement available on web thus not…
-
Stacked Chart
Hi All! I am trying to move a document from excel into SmartSheet and I was wondering if anyone knew if I could recreate this data into a dashboard chart? It is not currently set up as a chart in excel, it is a tedious exercise of lengthening and creating new shapes to designate the progress. I have tried a couple…
-
Preserving drop down list on import
Is it possible to preserve the dropdown choices when importing an excel document?
-
SUM of consecutive cells until blank cell is reached in the column
Hi, i am trying to SUM any given number of consecutive cells in column A and need it to stop once a black cell is reached. For instance The SUM will be column A, row 2 to 6 (7 is blank) and I am wanting the SUM to display in column B row 1. This will repeat throughout the sheet, but the SUM result will always be column B…
-
Vlookup or Index with Match?
Trying to get data from one sheet to another by matching on Deal ID to the Requests sheet from the Salesforce sheet Could someone please help me for the formula for this? this would be an import from salesforce that I would have to do manually weekly, so I could rename the imported file and use same column names each time.…
-
Streamlining sheets
We have a sales staff that is utilizing multiple sheets, for potentially the same client. I want to rundown the "standard" process to see if anyone can help streamline this. Sales speaks to customer, and enters into SmartSheet, almost as if utilizing like a CRM. This sheet will store details like Name, date contacted,…
-
count itmes in a column that is populated with multiple data
Hi guys, I have a new challenge for you :) . I have a list of projects. Each project contains different products. I have one probabilty column that contains all the probabilities to sell the different products contained in each individual project. An exaple: I have a project (1 row) where I can sell machines types A, B and…
-
Reports - pdf or Excel ?
I send regular reports to customers showing their expected delivery date of products. These dates can change frequently to suit their own construction schedules. Some customers prefer Excel format, others prefer PDF. If I need to change the email address of any customer, or add another name to their team, I am unable to…
