-
Hi-
While using the automated approval process, users are getting additional e-mail after they approve the request.
Is there a way to disable that? It just creates unnecessary e-mails and notifications serves to very little to no purpose.…
Using Smartsheet15
Enes Zorkul
-
Hi Community,
I've started a Software Issue tracker and so far I've found ways to display the information how I'd like it. I hit a road block when trying to display the latest comment a field on the spreadsheet.
I'd still like to use t…
Using Smartsheet216
Juston Oakes
-
In Chrome, the scroll bar works when you manually drag it but does not work while using the mouse. The manual dragging is a reasonable workaround but would be nice to be able to use the scroll around on the sheet without the scroll bar.
…
Using Smartsheet88
Melissa Campbell
-
I am trying to create a formula to change a Date column to update to the current date when another column has been changed. I have used the TODAY function within IF but this updates the current date every time the sheet is opened and saved…
Formulas and Functions9
Priscilla Awad
-
Hi,
When there is a workflow to copy a row to another sheet, why does the copied row sometimes appear down at the bottom of the sheet, leaving ~50 completely empty rows in-between the last row or text? I know technically smartsheet must b…
Using Smartsheet6
Julia C Peterson
-
Hi. Is there a way that I can have a dewey decimal system kind of the numbering for the items on my worksheet. I have found a solution that lets me have items numbered in the format 1.1 and 1.1.2 and 1.1.2.4 etc. But I want a system where…
Using Smartsheet19
Naveen Srikakulam
-
I have a list of employee information in one smartsheet. In another smartsheet, I'm recording events/things about employees. I'd like to have a dropdown list that have the list of employees names (from the other sheet) that I could use t…
Formulas and Functions572
Robin Soprano
-
Hi Folks,
I have a project sheet shared amongst my team where various "editors" are constantly updating statuses, priorities, etc. I have a sort set to first show project status, then priority, but am finding that all of my …
Using Smartsheet186
shellyj
-
I am trying to use SUMIFS with multiple criteria, and I am failing horribly. I seem to be having trouble when I try to add the criterion to sum data from a specific year (from a Date field) and/or when I attempt to add data from a date r…
Using Smartsheet18
Andrew Brimer
-
I am trying to pull contract numbers from an Active Contract file over to a 2nd file using the customer name as the unique identifier which is working just fine via INDEX(MATCH), however, if a customer has more than 1 active contract it on…
Formulas and Functions13
Lexie Ozolnieks
-
Hello, I am wondering if there is a way in Smartsheet to version control the sheets. Basically, we are using each sheet as an individual project plan. However, as projects progress, the plan will (usually) slip and/or have to be updated, s…
Using Smartsheet443
Ivana
-
Is there a plan to include Office documents such as Word Docs or PowerPoints into the functionality of proofing without having to convert them to PDF for uploading them?
Using Smartsheet159
Michael Lockwood
-
Hi all,
I hope you're well and safe!
I've developed a solution that lets you store the date or value.
You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work.
We'd trigger the copy-row to another sh…
Formulas and Functions255
Andrée Starå
-
Hello,
I'm using health circles to indicate progress. However, I want the circles (green, red, yellow, and gray) to show active stages in the process (complete, incomplete, in progress, on hold, respectively). I want phases that are not y…
Formulas and Functions12
Esperanza Zagal
-
Hi, is it possible to populate the contents of a dropdown list from another smartsheet?
API & Developers2534
HankBento
-
I have two task lists with slightly different columns, but there are some overlap - like status, completion date, & targeted completion date. I would like to run a report or some how combine all the tasks into one report/view/sheet - w…
Using Smartsheet617
latsyrcg3
-
I have a column that I'm setting to the type of Auto-Number/System that I'm setting to Created (Date). Some time later, it changes itself back to a regular Date column. I've re-set it numerous times and it keeps happening. Each time, I …
Using Smartsheet44
Nicole Campbell
-
We are having a problem where accidental sorting occurs on a sheet used by several users, and I am looking to only allow users to enter data into a cell, but protect the placement of columns and rows.
In my research I can not see a way to…
Using Smartsheet1137
JenM.
-
I searched but didn’t seem to find the issue I’m having posted previously.
I would like to set up automated alerts to individuals (contacts) based on a date triggered event however the base sheet has way, way more information than is nece…
Using Smartsheet253
luke_dubas
-
Hello,
I've had a colleague come to me with a query about how best to link 2 sheets. Her enquiry includes a handy diagram:
(Image) I'm wondering if cell linking would be best bet here? I realise this would obviously require her to keep hav…
Using Smartsheet21
SteCoxy
-
Hi,
Is it possible to update the information of a Sheet by replacing it with a new version of the sheet.
In our current process, we have daily approvals, however by using an approval request or an update request, requires a lot of effort…
Using Smartsheet24
Tania M.
-
See attached image
The Parent Row shows 7% complete based on the 1 item being 100% and all other items being in the future. The target % complete shows 20% which makes no sense to me.
There is a formula for Target % complete:
=IFERROR(…
Formulas and Functions34
LLaCosta
-
I am pulling data from multiple cells within a Project Sheet. The issue is that for each cell, the information is being presented differently. In some cells, the data is presented BELOW the Cell Title while in other cells, the data is pres…
Using Smartsheet337
Bryan Sampson
-
I'm having trouble with the multi select dropdown option. I have a sheet with the data/responses. I'm creating another reference sheet trying to count the responses. So example, here's my test data. There are multiple options for fruit.
(I…
Formulas and Functions17
JulieH
-
(Image) Hi,
I am trying to track progress through various stages of publication (the columns titled approval, data collection, analysis...accepted). I thought the health bubbles may be a good way to quickly visualize progress but it is c…
Formulas and Functions20
Esperanza Zagal
-
(Image) How can I get the Completion Rate to only show 100% rather than 150%?
Formulas and Functions24
Ashley Pierce
-
I have a number of sheets whom current owner are no longer in the organization and the email associated no longer active.
How can I retrieve the ownership of said sheets.
Thanks
Using Smartsheet25
Santino Di Renzo
-
Our small company does several projects at a time and all of them basically follow the same project plan. We created a nice template that contains the dozen or so tasks in our project.
Most of the reports and dashboards I've tried to crea…
Using Smartsheet670
Fairorth
-
Is there a way to link one sheet to another sheet creating a drop down menu?
Example: I am creating a form, but I want to the staff to be able to select the residents from a drop down menu.
I have the sheet created with the residents infor…
Using Smartsheet12
Kimberley Harris
-
Hi,
In recent times, my copy/pastes sometimes don't work. Most frustrating.
One consistent workaround is to log off from SmartSheet and then log on again and then immediately do the failed copy/paste.
It seems to be triggered by attemptin…
Using Smartsheet59
Rob Hagan
