-
Marrying 2 sheet datasets into 1 row?
Hoping someone might have come across this scenario. I have a three-step process where a phone scheduler calls to gain info from the client, then a field rep needs to go onsite and gather info followed by a report generated from both parties. A primary key for both parties inputs will be a Policy # The phone scheduler will…
-
How to know which system admin added a user to Smartsheet?
We have 4 system admins, and now I see a lot of new people have Licensed users, are Licensed users, which should Not have happened. How do I know, which System admin added these users as Licensed users? Thank you, Deepthi
-
Pivot on contact list - returns email address
When I use a contact list in a pivot the email address is returned, I'd like to see the name so I can use the Pivot in reports and show the name, not an email address. Is this possible?
-
Attachments
Hi, I am having an issue with being able to upload attachments to Smartsheet. (Both admin and team members) Any suggestions as to what is wrong with the system? Kind regards, Kyle
-
Deleted user receiving notifications
Hello - I deleted a user when they left the company. They have just informed me that they are still receiving notifications through the app. I have checked and we absolutely deleted the user, there is no reference to them in user management. Any ideas? Many thanks for your help, Tim
-
Moving Row Automation - Not Working?
Hi there, I was super excited to see some of the new features that were released this week, specifically the automation to move rows!!! I set up the workflow automation according to the SOP from Smartsheet, but it is not working (at all). Not one line has moved yet... any suggestions/advice as to why? Thank you, appreciate…
-
If with dropdown list
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, country dropdown list will show JP, SG, IN If chose Region AMER, country dropdown list will…
-
Scheduling by Skillset
Hello! I am wondering if you can set scheduling on Smartsheet, and if you can, a program on Smartsheet for scheduling based on employee skill sets on Smartsheet. If there is, how would I go about doing that, and what ways can we incorporate those skillsets for each employee under a saved file that can be easily edited as…
-
Free Collaborator / Unlicensed User
Hi, Just a small question is the Unlicensed User can also delete the row? Scenario: we have created a workspace and we want Unlicensed User to only edit the row but he/she can't delete the row. secondly: if Unlicensed User delete row or related information in row how the admin will get to know what happend or what is…
-
Nested IF Statement Formula
Hello Team, This would be a great formula to incorporate into my daily SmartSheets process within my organization. I would like to know how to create a nested IF statement if this is the correct formula to use, that uses an RYG (red, yellow, green) light flag formula to set the status of a task based on its…