We are excited to announce the release of Directory Integration for Enterprise and Premier plans!
Directory Integration allows you to connect and synchronize your Azure Active Directory to Smartsheet and much more:
* Provision Users: Lev…
I am using the new (preview) Smartsheet Admin Center "Group Managment" interface. In the old version when I wanted to add someone to a group, the "Add Member" picker would allow me to add users from our account and from…
Is there is a backup in the cloud of our sheets? Do you have any recommendations to prevent loss of data should something happen? Should we be saving a back up daily or regularly?
Using Smartsheet21Stephanie Bauder
This is Table 1
(Image) This is Table 2
The criteria is Match the Date & Name from Table 1 to find the Amount and put it in Table 2. And also add the amounts which is under the date tenure for the specific month.
After many re…
Formulas and Functions22Abhijit Aich
Is it possible to include Conditional Formatting in a Report?
I see discussion on this topic from a few years back, wondering if there has been an update or an easy work-around to include Conditional Formatting in Reports.
Using Smartsheet587Melissa Wells
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…
Is there a way to set different working days for individuals? I know that it is possible to define working days through the Project Settings function but I want to set this for one person only to reflect their part time working structure -…
Using Smartsheet21Harriet Blackborow
(Image) For example, for the DFM/DDFM Support Type, I would like to know that there are:
(1) Ashley Pierce
(1) Tanner May
(1) Alexa Briggs
(2) Ashley Pierce
Formulas and Functions19Ashley Pierce
Did something change? We rely quite heavily on these functions.
Any insight would be appreciated.
Thank you very much!
I'm trying to create a formula that counts certain actions in a column based on their date. Say, if there are three dates: 5/15/2020, 5/20/2020, and 5/30/2020, I want to be able to know which ones are in the future and which ones are …
Formulas and Functions26Carolina Rivera
I'm trying to set up a counter for a number of actions in the month of may, for example if I have 5 actions this month (May), I want the counter to return "5". I've been trying to use the formula below but all I get in return…
Formulas and Functions21Carolina Rivera
I'm trying to set up a counter for a number of actions in the month of may, for example if I have 5 actions this month, I want the counter to return "5". I've been trying to use the formula below but all I get in return is a…
Formulas and Functions22Carolina Rivera
I currently have a column that is supposed to add 14 days to another date column in the same sheet. The formula I'm using is: =["Date Column"] + 14
However, what I keep getting is "Apr 21, 2020 3:10 PM14". Both co…
Formulas and Functions23Carolina Rivera
Hi! I want to create an automated workflow which copies rows where two date columns are not equal to another sheet, how can I do this?
Using Smartsheet18Carolina Rivera
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…
I have a work approval request flow that being used to our department for document approval process.
We have one manager who accidentally deleted the approval request email and we don't know how to retrieved it since it was gone in to …
Formulas and Functions15Benjo09
I created a schedule and assigned task to the resources names. The names are showing up in the Gantt chart. How do I hide names ?
Using Smartsheet35Kumar Chellappan
I am trying to set an IF function to the At Risk column. I would like it to flag if the end date is within 2days or if the % complete task is less than 80%. Can someone help me set that function up?
This is what I am putting in;
I have multiple Smartsheets this has happened to, although I save and make sure prior to closing the SS it has been saved, and triple-check by the "save" icon being "shaded" prior to closing the SS. From time to time wh…
I'm trying to take ownership of sheets I am the admin of, it gives me the error, "you cannot take ownership of this item because the current owner is not in your organization".
My account was part of the parent company bu…
Using Smartsheet32Med Laz
For any Apple developers, have you tried the beta version of iPad OS, Safari and SmartSheet? I am so wanting to eliminate carrying my Windows laptop just for SmartSheet administration. The current SmartSheet apps don't allow it and neith…
Premium Apps and Integrations127Soccerrick10
I have added the email address for a specific Dynamic View I would like for them to access. Now what? How do I point them towards the Dynamic View so they can gain access and see it? Does Smartsheets send them an invite email…
Using Smartsheet94Stephanie Stoewe
Hello everyone, I hope you're all doing well!
I was using a premium account paid for by the parent company administrator, but they didn't pay this month, now I'm at home and I can't access smartsheet, it gives me the message in the screens…
Using Smartsheet14Med Laz
I have a lot of projects on separate sheets within Smartsheet which have rows assigned to users. If the user leaves the company, I can reassign that user's sheets to another user, but is there a way to re-assign the rows they are assigned…
Using Smartsheet14Tony Hatton
As a new user, I found that the % Allocation column does not respond to input from the Duration column, as seems intuitive to me.
After reviewing community comments, I find that the % Allocation functionality in Smartsheet does not actual…
Has anyone created worksheets to keep track of Client tasks for an accounting Practice?
Trying to keep up with all of the assignments and tasks in one central place
Using Smartsheet129Bal - CPA
I am trying to figure out if there is a way to make a Private Comment in Smartsheet? Let's say I have a Published Report that is viewable to anyone with the link; however, I want to make a comment on a line that I don't want anyone to be …
I have a smartsheet and there I will let people know when certain tasks have been executed. I have already created the workflow for that. My issue is when sending the email; can I add one row only on the email to notify that a certain task…
Using Smartsheet13Distribution Team
As an Admin I would like to run a report to establish what external users have been given access to our content.
All external users have to be in the approved domain sharing list, however what are they accessing?
Using Smartsheet87Gavin Burne
I have multiple sheets and dashboards created for different departments.
We are allowing editors the ability to add collaborators to their sheets. I need to track who has been added as a new collaborator across all the multiple she…
Using Smartsheet27Ivonne Mejia