-
I've tried multiple searches and haven't found the right keyword/tricky phrase to answer my question.
I am using a form for submissions and trying to calculate how long a trend has been occurring. Right now my working formula is this:
=…
Formulas and Functions32
Chris Rea
-
Hi
i have an approval workflow that isn't quite functioning as i'd like. It works as follows:
* A Payments Officer inputs data to a sheet and creates a row comment to add context
* they then change a status column to "Awaiting App…
Using Smartsheet103
L11CAS
-
My users are getting a little lost when they are sent to a sheet via an Alert or Update Request. It would help if there was a way to point them to the correct row.
I know you can get to the specific row via selecting the row, right clicki…
Using Smartsheet28
Dennis Wierzbicki
-
Hi everyone,
I have a team managing several projects (80+) at a time. I have setup alerts, reminders etc for each project.
So the same people will get alerts for different projects.
How do I incorporate the project name (which is the she…
Using Smartsheet37
Abhiraj Joshi
-
Hi All,
Currently I am setting up a tracker for tracking weekly hours spent on requests that come in via a form.
I would like to set up an update request that runs every friday (until task is marked as closed) to the assigned person w…
Formulas and Functions29
jg124
-
Hi all, I'm having a little trouble with creating the right formula for my "at risk" / "attn" column.
(Image) I only want the column to flag is the status is not complete and the target end date is past due. My current …
Formulas and Functions22
Titilope Akinlose
-
Missed the webinar?
Review the recording in the Learning Center.
Learn how to combine multiple automated actions that drive your processes forward.
In this webinar, we’ll demonstrate how to:
Streamline multi-step approval processes
Archiv…
Using Smartsheet97
Anna Mkrtchyan
-
It is very inconvenient that I am unable to move rows that have proofing enabled to a new sheet (keeping the proofs intact in the new sheet). We have purchased a new company and we need to move those company-specific rows to a new SmartShe…
Using Smartsheet19
jessical111351
-
Good Afternoon!
I am 2 months new to Smartsheet and enjoying the journey thus far.
Project Background:
I am working on developing a "master template" of tracking Objectives & Key Results (OKRs). In doing so, using the Maste…
Using Smartsheet21
William Laurento
-
Greetings -
I currently have employees getting multiple update requests in one email. Please see the attached screenshot for an example. I am needing these to come thru as individual emails and not multiple update requests grouped into o…
Using Smartsheet121
Jack C
-
This is Table 1
(Image) This is Table 2
(Image)
The criteria is Match the Date & Name from Table 1 to find the Amount and put it in Table 2. And also add the amounts which is under the date tenure for the specific month.
After many re…
Formulas and Functions22
Abhijit Aich
-
Is there a way to filter/sort by rows with pending update requests or even mass delete all pending requests?
Pulling together a list of pending requests for follow up as well as deleting all stale pending requests before the next automati…
Formulas and Functions20
Dustin Shuman
-
Dear Smartsheet Team,
PLEASE build desktop apps so that users don't have to rely on their browser to use Smartsheet.
If you look at most people's browser, chances are they have a million tabs opened. That makes it easy for Smartsheet tab…
Using Smartsheet36
Christina Wu
-
Did something change? We rely quite heavily on these functions.
Any insight would be appreciated.
Thank you very much!
(Image)
Using Smartsheet20
lisa.hollister84496
-
We have a form we would like to send to employees every morning, then be able to track each response separately. Tried automating the sending out of the form but when employees respond it overwrites the previous response because it was a …
Using Smartsheet31
Tiffanni Sanstra
-
Hi everyone,
I need to use INDEX MATCH formula to get a DS# with a CNDT# in another report.
The easy formula would be: =INDEX({DS Report Range 2}, MATCH([CNDT Number]1, {DS Report Range 3}, 0)), "") but the thing is that sometim…
Formulas and Functions37
Jose Rivera
-
Hi All, I'm considering using Smartsheet for a somewhat complicated process and I could use some help thinking through how this might work. I have the basics listed below but I would appreciate if the experts here could let me know if you …
Using Smartsheet54
joelmold
-
hi,
I have a work approval request flow that being used to our department for document approval process.
We have one manager who accidentally deleted the approval request email and we don't know how to retrieved it since it was gone in to …
Formulas and Functions15
Benjo09
-
I have an automation workflow in one sheet that I want to use in a different sheet. Is there a way to copy this workflow and then add it to my other sheet (similar to how you can copy summary reports from sheet to sheet)? Or do I need t…
Using Smartsheet287
sdonnelly
-
I set up indefinitely recurring update requests. Currently, I have to manually delete the update request when I receive the requested information. Is there a way to automate turning off a recurring reminder? For example, if I have a &qu…
Using Smartsheet24
Kevin Minkoff
-
I'm sure this is simple, but I've searched for a while and haven't found anything similar!
I have a sheet set up to track each piece of marketing collateral. It starts w/ the beginning quantity (say 100 pieces) and deducts the number of…
Formulas and Functions37
skarkhoff
-
Hi, I'm quite new to workflow and I'm trying to achieve the following:
A document need to be signed by 2 signatories, signatory 1 received an automated update request from workflow 1 which works well. I want workflow 2 to automatically req…
Using Smartsheet32
Nicolas Raffray
-
Hi,
Is it possible to change the "from" address when sending automated alerts/update requests? Or is it always the default SmartSheet address?
Thanks
API & Developers230
twa10028
-
Since Smartsheet doesn't have the option to resend update requests that haven't been completed, I wrote a script to pull all sent update requests, filter on pending requests, generate+send new requests, and delete the original request. Th…
API & Developers26
Sheanon Summers
-
I have an approval workflow set based on a cell value. Is there a way to update that cell value once the approval completed?
Cell dropdown example:
1. Under review
2. Sent to team
3. Ready for release
4. Released
When the cell chang…
Using Smartsheet1160
sarshad
-
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
-
The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design req…
Using Smartsheet149
amontemayor
-
I'm trying to use Approval Requests for something and some of the columns are analysis's and are written in paragraph form. This is a formal process and I want it to look as professional as possible. Even though in smartsheet I can use Ctr…
Using Smartsheet32
Julia C Peterson
-
While I understand the benefits of a sheet's workflow combining multiple rows into 1 update request, if the email field for all of those rows match, is there a way to not combine and send an email per row, meaning a user may get multiple e…
Using Smartsheet16
Dustin Shuman
-
I spent 15 hours trying to organize my data in an efficient way and just can't come up with a good solution. Smartsheet is great but SO limiting if you are used to Excel.
I have 200+ sites that each has 31 activities. Each activity has 3 d…
Using Smartsheet55
Melisa Dannhauser
