I'm pretty confused on what defines a "User" in Smartsheet. When I go to User Management section I can see a list of my users, currently 18. I know however that there are probably 60 people in my organization that sheets are shared to and they have edit permissions on those sheets. Why don't they appear as users? Where…
Hello. I'm working on importing resource allocation data from an external source into Smartsheet. This includes thousands of rows of data, including a column of employees names in text form. Is there a quick way to convert an employee's name from text to their name from our Contact List (so it appears in the Resource…
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 ?
How can I set the criterion [if 'past one week from the due date' colour progress bar red] for any given task.
Hi There, I have a number a approval workflows set up and only some are sending email notifications. I am trailing it between my smartsheet email account address and a seperate personal one. Workflow 1: When a row is added via a webform it triggers an approval to a specific email address (my non smarthsheet account email).…
TL;DR I want to copy a cell from Sheet A (which has an inbound link from Sheet B) and paste into Sheet A while retaining the inbound link. Currently, when I copy the cell from Sheet A and paste into Sheet A, it only pastes the value of the cell and loses the inbound link.…
Hi Can you all please view the attached file. The problem is self-explanatory: whether the duration is normal (the 1st row), or it is written with the letter "e" (for elapsed time), the Finish date remains the same! I have checked and my sheet has Sundays defined as holidays. Please help! Nasir
I am hoping to use smartsheet to capture some user data related to project planning. When I export my view to excel, the data requires significant manipulation in order for the parent and children rows to align such that I can analyze the data using pivot tables, etc. I am hoping that there may be some best practices or…
Hello, This might be a silly question, but if I have an automation trigger set for "When rows are added or changed", is Smartsheet "smart" enough to recongize not to fire an automation that was triggered by an approval automation? For example, I want to request an approval whenever a new row in my sheet is added (which is…
Hello, I have a primary column with Ctr numbers, but filter is not working is it because is a primary column?
How would one go about getting access to a sheet/form if the person that created it is no longer employed?
Hi there, I am hoping to find a way for our staff who submit information through form to receive an email confirmation without having to get a copy of the information they fill in the form. At the moment the only email option is to have them get a copy of their response to the form, but I don't want them to have a copy of…
How can I customise an update request in a workflow, so that the updater has fields that are required to be updated before submitted the update?
Help shape the future of Smartsheet. Share your ideas and feature requests.