-
Use "Created By" auto generated field as a "contact list" for use with approval workflow
I have a form that is use to submit travel requests. I would like to set-up an auto-field that captures who the form was "created by", rather than having them enter their name into the "contact list". I was hoping to use this to then send an auto-generated workflow to this contact. However, I believe workflows only work…
-
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
-
Command D not working or user error?
I recently switched to a Mac and am trying to get all of my new shortcuts down and I cannot get the command-D functionality to work. I have tried it on index/match formulas and simple arithmetic formulas as well with no luck. When I have a cell with a formula, I am highlighting that cell and pressing and holding command as…
-
Add attachment to multiple sheets and respond?
I have a form where my customer can request certification documentation. The form logs in a Smartsheet for tracking requests. The automation sends an update alert out to my team, requesting a response. When they respond to the update alert, they can attach a file. What I would like is for the attachment to be added to the…
-
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…
-
Formula to calculate the amount of "done" rows for different years.
We do a lot of service jobs that we use smartsheet for. When its done they mark status as "Done". I know I can find the total amount of done rows by: =COUNTIF(Status:Status; "Done"). But how do I make the formula filter for jobs done in 2018 or 2019 etc? Kind Regards, Hugo Martinwall
-
Automated Update Request for Multiple Emails
Hello I set up an automated update request to occur every Monday morning for users in a specified column. This column allows for multiple emails per cell. I am getting reports the emails are not going to all users. It seems like there may be an issue with sending the email to those emails that are second or third in the…
-
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…
-
Filtering/Slicing in Dashbaords
Hello SmartSheets Team, I am a little new to SmartSheets, but I have successfully built a dashboard with all the data I would like. However, I can't seem to find any functionality that allows me to filter/slice the data in the dashboard view, say to specific users or anything like that (for example, I can see total sales…
-
Copy of My Response Email
Hi, there. I have a couple of questions regarding the email that is sent when a user chooses "send me a copy of my responses" when filling out a form. 1. The email is coming through with a high importance flag. Is this standard? Is there a way to change this? 2. The email sender is forms@smartsheet.com. Is there any way to…
