Solution Center
Discussion List
-
Mail Merge with FormIn Premium Apps and IntegrationsHi all, I was searching on the Smartsheet community, but i could not find the best solution for my issue. Basically, in my company, everytime that a production finishes, i receive via e-mail the test results for the specific product. …
-
Dashboard automatic updatesIn Using SmartsheetHello, I am looking for a way to send a weekly message to a group of shared users to view the team's portfolio dashboard. Currently I have a scheduled report that is sent weekly, I want to do the same with the dashboard. Thanks Michelle
-
Need Formula: "Is this person listed again in the next week?"In Formulas and FunctionsI'm trying to figure out how to build a formula with this logic. When a person is listed on a row with start and end dates, are they listed again for an upcoming event in the next week? Is it possible to create a formula that gives a yes/n…
-
Help on formula: format numbers and shorten to K (thousand), M (million), B (billion)In Formulas and FunctionsHi all, So I was able to get help around here on how I could turn amounts in thousands and millions to just K and M instead of displaying lots of zeros. Now I would like to add a formula in to just round it up with just 2 decimal places a…
-
21 CFR 11 ComplianceIn Using SmartsheetI work in medical devices, and I have been trying to figure out whether or not Smartsheet meets FDA 21 CFR 11 requirements? Because I would like to use Smartsheet for our logsheets. Does anyone know whether or now Smartsheet meets FDA …
-
I created the Coronavirus Preparedness Template Set. How can we improve it for you?In The New Work/Life RealityHey everyone! I am a Product Marketing Manager at Smartsheet who helped create the Coronavirus Preparedness Template Set available on Solution Center. It’s exciting to read the feedback you’ve submitted and scroll through LinkedIn to hear …
-
Volunteer AllocationIn Formulas and FunctionsHi All, 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…
-
CountIF for a multi-select drop-downIn Formulas and FunctionsHello, I'm using a column to track what each row requires as a next step in the project. In some cases a row will need both say "requirement A" and "requirement B", therefore I'm using a multi-select dropdown because i…Answered - Pending Review 15 views 3 comments 0 points Most recent by David Joyeuse Formulas and Functions
-
New Template Sets for these Workflow Categories! Let me know your thoughts!In The New Work/Life RealityHey everyone! As a Product Marketing Manager here at Smartsheet I am always thinking about how we can produce content that helps you work more efficiently. Especially now, we are producing new Template Sets that will help you and your orga…
-
Why won't my COUNTIF formula not count anything from source sheet?In Formulas and FunctionsHi all, I currently have a system for three spreadsheets: 1) Masterlist for open/closed actions that feeds a 2) Open Actions sheet, and a 3) Closed Actions sheet. The formulas for the first two sheets work perfectly, however, when it come…
