We are using SS and considering DMS options (Efilecabinet, Box, M-file) to manage the bulk of docs we handle in the process.
Wondering if anyone in the community that has a DMS in place can provide feedback or advice on their …
API & Developers135tcalvey
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 Functions63KDub618
Does Smartsheet allow for integration with Access database tables?
Is this something that a connector is needed for; such as Data Uploader?
Will the integration work with older editions of Access or only Microsoft 365?
Premium Apps and Integrations592Jwindels
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 Functions343Alexander Wirtz
We've been hunting high and low for a good task mgmt system for weeks, and Smartsheet is looking very promising. However, there doesn't seem to be any primary or foreign key type functions. How do you relate two sheets with eac…
Formulas and Functions858SeanR
I want to be able to validate data in a drop-down menu in one sheet from a column in another sheet.
EX: I have a sheet that serves as a master sheet of projects and the project's properties (Name, budget, etc.), and another sheet that …
Using Smartsheet127Benjamin Hatmaker
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"
Formulas and Functions1291LouiseM
Setting up an alert system that sends out notifications when a form has been completed.
To streamline the process I would like to use a field from the form in the email title to differentiate between the emails rather than a range of emai…
Thought I would start my own thread regarding this since it seems very quiet around this change.
Am I the only one having no luck in using the suggested shortcut CTRL ] to indent?
I am using Windows 10, Chrome webbrowser and swedish keyb…
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…
I am creating a dashboard and I need to add a resource view to it, to show the resources assigned to a specific project. Is there any way to do this?
Also in the resource view, is it possible to limit the projects considered to ca…
I have my sheet set to show rows in descending order of dates, from most recent to oldest. However, when I use the card view, it shows the cards in the reverse order -- from oldest to most recent.
Is there a way I can sort my c…
I was looking all over the Community page and I was able to find the help I needed to make my statement work but when I changed the column in the statement it would stop working. I was hoping someone could explain the difference to…
I am trying to auto populate effective dates for benefits and I cannot get the calculation to work past the first part (60 days after start date)
I need to have the following result as an example
Start date: 1/15/2020
Formulas and Functions319ANA G
I need to be able to generate a simple format based on the data that exist in smartsheets. I store information such as news updates and I would like to be able to create a report that generates the text formatted in a specific way.
API & Developers260MikeLord
I have a sheet with a list of assets. There is a pull down menu that defines the status - I need to know when the menu is set to "complete". I can do that easily with a filter - but I want to cull the entries before a specific da…
Formulas and Functions1101CamCrichton
I've discovered that text is no longer behaving well within the cell. I'm see words cut off within the cell, whether or not the cell is formatted to wrap the text.
Thus, it makes copying the text and pasting it wonky. I oft…
Using Smartsheet94Loann McGee
Have a super basic question I just can't seem to find a quick answer for.
Want to sum cells with both numbers and text in them like "15 min" + "15 min" and get the result of "30 min". I formatted the cell wit…
Archived 2017 Posts6575Dereck H
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 Posts87Michael.Baker
Hi - our company is looking to hire out a hospitality box in London for a 12-month period that hosts events all year round. We would like internal employees to be able to view the event calendar and to book slots for a specific date where …
I'm not aware of a current way to do this, so I'm wondering if it's on the dashboard for enhancements.
In our use, we find ourselves needing to attach/copy the same documents from one line to another and currently the onl…
Archived 2015 Posts1031Loann McGee
Hoping you might be able to assist me with a similar issue I'm experiencing. I've attempted to import a Trello board into Smartsheet for one of my colleagues and I'm getting the same error message, when I view it in grid view on so…
Formulas and Functions158SteCoxy
We're using Smartsheet to plan content development and scheduling for a radio station. We'd like to create lanes in the Card View for each day of the week (I already know how to do that part). But each row in grid view already h…
Formulas and Functions53dchouston
I have my priorities set up for high, medium, low. I'd like to prioritize within the highs, lows, etc.
I'm used to working of an ABC, 123 set up.
Using Smartsheet77Judy C.
My org used to use the “Send” or “Send Update Request” option from the fly-out menu on each row quite frequently. That feature is now only available to licensed users, I believe, as Smartsheet moves people to use conversations in the comme…
Using Smartsheet42Laura Brady
Hi, I am trying to get the % of tasks complete.
The column is a checkbox type.
This allows me to get the number as long as all columns are 1 (checked) or 0 (unchecked)
=ROUND(100 * (COUNTIFS(ES2:ES36, 1) / COUNT(ES2:ES36))) + "%&q…
Formulas and Functions32dolores_ken
I'm trying to come up with the formula to dropdown only certain countries if chose certain region.
I have two dropdown columns Region and Country
If chose Region EMEA, country dropdown list will show DE, DK, NO
If chose Region APAC, cou…
Formulas and Functions42seeble
A question was asked of me today if there is multiple choice column in development. We use the drop-down list column, but one that allows you to choose multiple entries would be fantastic.
Archived 2015 Posts387Loann McGee
we are displaying dashboard on TV on open space hall. To keep TV login secure, we are using account without licence, and this user is Viewer only. But when we tried to set up Auto-Refresh rate to 1 minute (it is important to see dashb…
Using Smartsheet67Daniel Dragoun
Update requests are great, however none of the comments get stored within Smartsheet but only get sent as a part of an email. This way discussions get lost that should remain part of the row it is about. Copying and pasting these discussio…
Archived 2015 Posts112Monika Vermeulen