I have a multiselect Assigned To column linked to a contact list. So the contacts are displayed with their full names. Email addresses are shown in the hover over menu for each contact as per usual.
I want to count how many of t…
Formulas and Functions20Martina Barnett
I am working on creating a report in which data is obtained using a Smartsheet form.
For each new answer on the form…
Using Smartsheet20Jefferson Ribeiro
I am pulling information into a Microsoft Publisher label template from Smartsheet using ODBC smartsheet live data connector - this all works fine but any columns that are formatted in smartsheet as date columns are switched from UK format…
Hi SmartSheet community!
This may be an odd one to describe but I am going to try my best. I have a process that is a bit circular and is also a "maybe situation." For our product, we will go through rounds of optimization but o…
Using Smartsheet25Zoe Charalambous
How do you expand the height of a row?
Using Smartsheet16Danny Sax
I spent 15 hours trying to organize my data in an efficient way and just can't come up with a good solution. Smartsheet is great but SO limiting if you are used to Excel.
I have 200+ sites that each has 31 activities. Each activity has 3 d…
Using Smartsheet32Melisa Dannhauser
To give a little bit of context, I am creating a report where I can count whether a cell has been filled with information. The column I am using is a drop down list with 5 values. Let's say these values are apples, bananas, oranges, pears,…
Formulas and Functions13Jennifer Molina
The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design req…
I have an "Request Approval" workflow I created back in August 2019 that was working perfectly fine until late last week. I can't find any reason for it. Nothing was changed on our end. Is anyone else having automation problems??
Using Smartsheet14Alejandra Orihuela
I would like to know please what will be the best way to delete rows which their time stamp i more than 24 hours. i can't find a delete function under the conditionl function.
Using Smartsheet189Tal Segal
I am an enterprise user with Smartsheet.
I would like to setup a custom domain for my clients to access their Smartsheet view.
For example: portal.mydomain.com
They will be able to login using their custom credentials and acce…
Using Smartsheet26Steve C
I have a main grid with several columns and a webform that feeds into that grid. This tracker is used by my team to track several job "types" defined in one of the destination grid columns as "Large Project", Medium Pro…
Using Smartsheet18Nikki Hopper
I would like to send a notification with an attachment based of a status change. The notification works, but doesn't include the attachment. I have seen on the community that this is not possible in SS - is this still true?
API & Developers153katherinehall
I am trying to use the RYG balls when noting when a variance has gone over certain amounts:
5000 or less - Green
5000-10000 - Yellow
over 10000 - Red
I can add grey as my false statement if the coordinator has checked off the completed box…
Formulas and Functions38Marina Dixon
With the Dashboards, I am able to create charts from a sheet but not from a report (this requires using the report widget).
I collect weekly "submission date" data from 40+ people. I have created a report that shows when the sub…
Using Smartsheet271Pam Tadsen
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 have developed a project schedule that is detailed and has information that should not be shared with the client. In order to provide the client with a summary view, I am using a checkbox column to mark the rows that should be client fac…
Formulas and Functions69Barbara Silva
can someone suggest a simple way to mark cell (or rows) that one of the columns with Duplicate value
thanks in advance
Formulas and Functions306odedL
Hello, is it possible to export only the filtered rows to excel? When doing the export, it will hide the rows that were filtered, but they will still be in the excel so if I try to copy and paste or create a mailmerge, the excel will also …
I have set up an automation rule to, when triggered, copy rows to another sheet. My trigger is a certain field that changes from 0 to 1.
I've tried a couple of times and non of my rows are copied.
To test it, I added to the same automatio…
Formulas and Functions48Stelina Todorova
There seems to issues with date formats at the moment. I've had a few client's reach out with issues and I've also seen issues from others in the community.
If you're experiencing issues and If you haven’t already, I would recommend…
Using Smartsheet56Andrée Starå
I am working on a sheet for currency of qualifications for our employees. I have the equations that will tell me how many employees are a month before they are due, how many are due this month, and how many are in the past but now I have t…
Formulas and Functions17MiKayla McCready
Okay, I'm trying to write a formula to automatically populate a contact based off the information selected in a multi drop down.
I have a separate sheet that lists the appropriate contact for each item (Sheet Name: HR Contact for Reminder…
Formulas and Functions27Briana White
I have a formula I am using on one sheet. The sheet is named "Mark" since he is the Point Person.
=COUNTIFS([First Contact Year]:[First Contact Year], "2020", [First Contact Month]:[First Contact Month], "J…
Formulas and Functions37John Morgenthaler
I am trying to count the number of cells that contain certain words, such as "NYSEG" or "RGE," when the cells may contain more than one of these words.
I have tried using =COUNT(FIND("ConEd", [Utiliti…
Formulas and Functions200ecosbar
I have a sheet where i am tracking multiple different tasks for completion. i am attempting to create an (Overall status) once a few key items are marked completed, and or box is checked.
Can someone explain how this can be done?
Formulas and Functions13Daniel Pochop
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
When dragging the email from my Outlook window to Smartsheet in Google Chrome it removes the file from my Outlook entirely and the email is gone.
I tested this in MS Edge and confirmed it does not happen when using Edge; the file copies a…
API & Developers318mschwahn
I faced this issue when three and more files are attached to the row. In this case, their numbering becomes incorrect. For example, the latest version of the file can be marked as V2 or V3 whereas it should be V4 (in case if four versions …
Using Smartsheet14Aliaksandr Ilyuk
Trying to figure why this isn't working...the first two formulas seems to work but adding the third gives me the #INCORRECT error...Please let me know what I did wrong? =IF(ISBLANK([1st PRODUCT_OWNER APPROVAL]@row), "", IF(ISBLAN…
Formulas and Functions21Shirley Vue