-
Summarizing Time sheet data
If I use a webform to collect time sheet data by employee by customer by task how can I then summarsie that data X date range X Employee x Customer x Task and visa versa.
-
Avoiding double entry in multiple sheets.
I currently use Smartsheet for one purpose and still use Excel spreadsheets for another purpose. I have however hit a problem and wonder if anyone can help and provide a solution. Currently I have a sales spreadsheet for each employee. Each sheet contains a range of data. The range is the same on every spreadsheet and it…
-
Smartsheet Business Case
I am trying to build a business case for my company to adopt Smartsheet, do you have something that could help me doing this? Like issues and how Smartsheet addresses them, how it can streamline busniness processes and projects. Benifits, uses, etc.. We are in Financial Services and Investments. We manage alot of projects…
-
How can i create a hiperlink for a cell in google sheets and link it to a cell in smartsheet?
Hello Everyone I am in the process of creating a budget sheet in smartsheet. I need to have a total monthly amounts transfer from google sheets to one cell in smartsheet. Also, when data is updated in google sheets also will update in smartsheets. Try to get a link for one cell but I can't find a way to do this. Any ideas?
-
Setting up incoming payments.
I see so much potential for this product in my small business and I'm really excited to try and find a solution for my issue. I have have a business with approximately 650 clients. Most of my clients are on a payment schedule (some weekly, some bi weekly and some monthly). I'm trying to figure out how to keep each clients…
-
Day of the week formulas
How do I schedule repeating appointments on a specific day of the week; Ex: Every Mon at 10:00 First Tue of the Month at 09:00 I did not see the day of the week variable or formula. Thanks Alan Guggenheim
-
Multiple projects and hour registration
Hi there, we are new to Smartsheet (testing) and would llike to registrate our EU projects. * - Registration of multiple projects * - Fill in the available budget * - hour registration from employees on these projects (different from budget) * - different hourly rate per project per person * - Tasks and deliverables within…
-
Using as Consultant to Businesses?
Does anyone have any "best practices" in using Smartsheet in connection with consulting to businesses? I'm an "outsourced" or part-time CFO/Controller to a variety of businesses. Usually, the business has staff that will perform work under my supervision. Thanks in advance!
-
AIA Forms
We use an AIA form process for the pay applications in our industry. I am wondering if anyone else has been able to implement an AIA form in a sheet?
-
Secondary Formula in an OR Cell
Is it possible to have a sub formula be part of the main formula for an IF/OR cell? Basically what I am trying to do is write a formula that looks at Column A and if it is one of two answers from a drop down list report the percentage of the value of Column B, and if the value of Column A is a third value return 0. The…
