-
Hi there,
I have set up Smartsheet so that when a Customer Order is fulfilled, the row of the Order is sent back to the Customer as an Order Confirmation. Also, we attach the Invoice for the Customer Order which should be sent back in the…
Using Smartsheet473
Andy.Mott
-
I have one sheet that has metrics for a few of my employees, I was hoping there was a way to get the drop down menu function for each employee transferred onto a Dashboard highlighting everyone's metrics.
*The drop downs show their total …
Using Smartsheet395
NicoN
-
Hi,
Is it possible to create a pdf report based on one form entry? I know I can send an email confirming what has been entered on a form, however I would like to make this a pdf attachment rather than the body of the email.
Lauren
Using Smartsheet67
Improve Consulting
-
Hi,
I am trying to implement the following formula from my excel spreadsheet into my smartsheet:
=INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes"
Basicall…
Formulas and Functions949
LouiseM
-
Hi all,
I searched and I didn't find anything for this so I am hoping I did not just miss this.
We are trying to tie our data into Microstrategy for more visualization options. We are using the Live Data Connector. Has anyone been able to …
Premium Apps and Integrations34
Liz Beall
-
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken pla…
Using Smartsheet76
Shah_0614
-
Hi,
I'm trying to create a form that is dynamic wherein the other fields will changed when a certain category is picked.
For example, selecting category: printing project that will have how many pages, if it's double sided and what ty…
Using Smartsheet409
lmatawaran
-
How do you extract numbers out of a cell that is formatted in a 12-hour clock and paste the numbers into another cell? I need the column "Time Duration" to know the difference between the "Start Time" and "End Time…
Formulas and Functions18
FugroKyle
-
I am trying to capture the total number of active projects found in a specific Workspace. Each project is its own, separate, SmartSheet. The way I am able to do this now is by manually creating a Formula (COUNTIF({Proj Name Range 1}, "…
Formulas and Functions1976
Bryan Sampson
-
I am using the backup tool provided through the below link with SmartSheet. The issue we are running into is that we do not need it to backup every single user (this is time consuming and bloats to over 3 gigs of data currently). We are …
API & Developers26
Timothy French
-
Hello!
Has anybody had experience trying to automatically move a row containing formulas to a new sheet? I am trying to pre-populate cells with formulas that would apply on a different sheet so that they will be ready to go once moved ov…
Formulas and Functions177
Rooke Jackson
-
I'm trying to count the number of unique pieces of equipment that are on my worksite. Each unit has a specific Unit Number listed in a sheet. Units that are On-Site are indicated by a green dot in another column. The tricky part for me is,…
Formulas and Functions46
Drew Frazelle
-
I searched through the Community and found a couple of formulae that either directly addressed what I want to accomplish or I thought could be modifed to do what I want. I get the #UNPARSEABLE error for each of them. I'm sure I'm missin…
Formulas and Functions74
Pat Sullivan
-
So. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use.
It has many application & the proof of concept exists and we use it.
We use it for an approval process (for in…
API & Developers1142
JeremiahHorstick
-
When dragging the email from my Outlook window to Smartsheet in Google Chrome it removes the file from my Outlook entirely and the email is gone.
I tested this in MS Edge and confirmed it does not happen when using Edge; the file copies a…
API & Developers578
mschwahn
-
Hi,
Is there any way that I can export my data from smartsheet so that it automatically populates/merges into a template that i have (word document)
Thanks in advance,
Scott
Using Smartsheet36
Scott Rae
-
I was wondering if this is possible yet, or if there have been any updates?
https://community.smartsheet.com/discussion/how-import-outlook-calendar-smartsheet
Importing from Smartsheet into Outlook is nice, but I would love to have…
Using Smartsheet320
Paul Newcome
-
Does anyone know if it is possibly to set a box to check a certain amount of time after a date is imputed into a row.
For instance, we need a lag time on a project complete date of 48 hours. This is for a manufacturer that needs 48 hours…
Formulas and Functions43
dplunkett79331
-
Hi,
I’m part of an in-house legal department. The company has different departments and different types of contracts/advice they require us to produce.
To track the work, I have created one sheet for the legal team to use, covering all…
Using Smartsheet436
Tomer
-
I'm new to this, and I'm having issues with counting the number of projects where Project Type = X and Project Status does Not equal Complete or Cancelled. I'm fumbling my way through unsuccessfully. This will go on a dashboard where I hav…
Formulas and Functions87
Brian Lynch
-
When creating a project many times the comments are as much instructions, as comments. Just like this modal when creating community comments, add the ability to apply Rich Text Formatting; Bold,underline,bullets, and numbered lists. RTF fu…
Using Smartsheet89
Dantawn
-
I have a column set as Contact List and the Allow Multiple Contacts per Cell field is checked. I am using COUNTIF statements to count how many people are assigned to the tasks for a dashboard.
I am using the formula: =COUNTIF({Project L…
Formulas and Functions728
BryanHeft
-
Excuse me, my english isn't very well. I need your help.
(File) When I want to put an URL in smartsheet I click in the box to join an URL and on my mouse but nothing are been proposed to me (cut, copy etc). My mouse works very well except…
Using Smartsheet35
Lisa Savard
-
We're new user trying to understand how we can use daily schedule template to repeat itself on-going basis. When I go to settings it is grayed out so there goes that option. Spreadsheets are not something I've used too much and support is …
Using Smartsheet114
craig105421
-
First of all, english is not my native langage, please excuse my mistakes.
Hello all,
I have a smartsheet with several external counterparts (customers and providers). I manage the smartsheet which is not shared and nobody is able …
Using Smartsheet67
François Cales
-
Hi everyone!
Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified"
Here's …
Formulas and Functions78
lisarae723
-
Hi All,
I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
Formulas and Functions65
KDub618
-
I am looking for a way to filter on reports the same way you can filter on a sheet. It seems that on reports you can only sort whereas sheets allow you to filter. If this functionality is not available, I would like to request it be added …
Archived 2017 Posts567
Steve Mustafa
-
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down?
Below is the formula in E…
Archived 2017 Posts79
Michael.Baker
-
A number of regions (countries) have very tight internet use. It would be helpful to be able to download local version, work on it while abroad and resync on return.
Using Smartsheet110
creinink
