-
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…
-
Can you return a blank cell in a formula that isn't text?
Is it possible to return a blank cell which is then part of a formula that adds up with other cells to result in a monetary value? =IF(MILEAGE6 > 50, (MILEAGE6 - 50) * [MILEAGE EXPENSE]$2) I want values between 0 and 50 to return a blank and not a 0. When I do the above, it messes up the total column because it thinks the…
-
Printing of Web Forms
Hello, The Maryland State Department of Education would like to transition the Notice of Grant Award process from manual entry to collecting requests via a Smartsheets web form. A requirement of this process would be to recieve signature and initialed approvals on a paper printout of the form after it has past through each…
