I have a sheet published in Card View on our company Wiki page with Read Only - Full features.
I'd like to have the ability to set the Published Card View to match how I have my sheet set up and not a generic Card View.
For example, I h…
Using Smartsheet24[email protected]
Is there a way to save a filter as the default. I want the same filter applied every time the sheet is opened without the need to select it.
I want to use smartsheet as an international project management tool. One thing is driving me creasy.
I want to send out a notification to an assignee if the predecessor task is completed. Please find attached a screenshot of my scenario.…
Formulas and Functions127Alexander Wirtz
Does anyone know if there is a way to NOT display a contact's full email address (but show their name, instead) when they are assigned as "Task Owner" in the Smartsheet Calendar App?
We have a calendar that references an existin…
Premium Apps and Integrations37Kyle Morgan
I have a complicated project with tons of predecessors. The predecessor lines connecting tasks in the gantt view are so numerous that is makes the gantt visually hard to use. Is there are way to hide or turn off not the predecessors, but…
Using Smartsheet150Project User
Background: An International source Smartsheet has 1700 rows (and counting) and 85 columns. Using the Index/Match formula, we reference 14 columns of data within a new Regional Smartsheet. Why? Regions want to add additional Country-focuse…
Formulas and Functions207EmilyH
I have a date stamp column already in the SmartSheet. When a new row is added, a date and time are assigned. What would be the best method of tracking and reporting the time duration between when the row was added and when it was closed ?
Using Smartsheet54Steve S
Hi I would like to understand about this limitation in vlookup:
* Each sheet can include no more than 100 distinct cross-sheet references.
* There’s a limit of 25,000 inbound cells that can be referenced from other sheets into one sheet …
Formulas and Functions91Vivien Chong
We currently use Jotform for some of our forms here and would like to be able to bring more of them over to Smartsheet if possible
As you can see from the attached files, the form is set up to add a new line after each previous line is fi…
Formulas and Functions109TrevorM
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 Functions44dplunkett79331
I am a business license user, recently, I shared the report to the people. some of them feedback, since we forget the password, when they tried to reset passowrd by click" forget password", they got the message “ the request…
I work at a manufacturing company & have implemented Smartsheet to be used within every department. Right now I am currently the only admin who creates and/or updates the sheets, reports & dashboards etc. We have over 300 active sh…
Does anyone have a template or know of an existing template that could be used for OKR's?
As can be seen in the attached screenshot I have data that is brought into the sheet from a web form. A time and date stamp is attached at posting (this time and date is correct) however, the date column beside it that is derived from the…
Hello - The manufacturing site I work at uses Smartsheet to track site priorities. I would like to do resource loading analysis, similar to the functionality that is available in Microsoft Project. However, to do that all resources must …
Using Smartsheet26Katherine F
I have an action plan with an action column, a delay column, a referent column, and a progress column.
I would like to create a workflow that sends a notification (mail) to the referent of the action 3 days before the date ente…
Using Smartsheet37Thibault P
To proof I have to first upload a file, but what if the file had already been attached to the row; is there a way that an attached file can be automatically moved into proofing.
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"
Formulas and Functions61lisarae723
As of this morning, I have found that Smartsheet is defaulting my sort order to Name. I can change to Last Update on a specific workspace, but when I click into another workspace, it defaults back to sorting by Name. Previously, the sort…
Using Smartsheet35Jason Reckelhoff
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 Functions50KDub618
I am an Admin of our account and want to see what smartsheets are owned by each user and the activity on each sheet (date/time). Logs only shows me logons. I need to verify that licensed users are really using the product.
I put a tic…
I have created a simple sheet with data for internal materials requests, including an approval loop via workflows.
I then created a webform to gather input; in order to test it, in the approver / exectutor user fields I used fake d…
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 Posts55Michael.Baker
A sudden shift of rows happened while using smartsheet. The detail is as follows:
Three people worked on a same spreadsheet. One was changing the arrangement of rows, such as shifting row 2 below to row 5, while other two were inp…
Using Smartsheet24E Sa
How do I create an 'At Risk' report, from a sheet, to include on my dashboard?
Using Smartsheet24Amanda Chiancone
Is this possible, only seem to be able to add one at a time, is there a way to add multiple?
I would like to apply smart sheet to my workstation for daily manufacturing status board.
Is there any chance for me to change gantt chart scale from date to time.
Archived 2016 Posts42Junho Kim
Hi. My name is Frank. I have been working on this formula for quite a while now including requests to Smartsheet support. The formula is to raise a red flag when the end date is less than 3 days away with specific status options. I finally…
Formulas and Functions53FEspo
I work in company established in Germany. So my english writing can confuse you.
I am new here and want to ask a question regarding the workflow / alarm tool.
The automated mails are linked to a formular or the receiver gets …
May I know if there will be any alert when a sheet is reaching it's 5000th row?
My team is working on my sheet as free collaborators, can I be alerted when the sheet is reaching the maximum capacity?
Using Smartsheet27Vivien Chong