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 Smartsheet15Enes Zorkul
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 Smartsheet216Juston 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 Smartsheet88Melissa 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 Functions9Priscilla Awad
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 Smartsheet6Julia 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 220.127.116.11 etc. But I want a system where…
Using Smartsheet19Naveen 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 Functions572Robin Soprano
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 …
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 Smartsheet18Andrew 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 Functions13Lexie 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…
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 Smartsheet159Michael Lockwood
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 Functions255Andrée Starå
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 Functions12Esperanza Zagal
Hi, is it possible to populate the contents of a dropdown list from another smartsheet?
API & Developers2534HankBento
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…
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 Smartsheet44Nicole 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…
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…
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…
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 Smartsheet24Tania 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:
Formulas and Functions34LLaCosta
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 Smartsheet337Bryan 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.
Formulas and Functions17JulieH
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 Functions20Esperanza Zagal
(Image) How can I get the Completion Rate to only show 100% rather than 150%?
Formulas and Functions24Ashley 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.
Using Smartsheet25Santino 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…
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 Smartsheet12Kimberley Harris
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 Smartsheet59Rob Hagan