-
Can an Admin see what I have created as an owner?
I have created some content for VPs, HR, etc...that others, including the person who is our Smartsheet Admin, should have access to. I just want to confirm that NO ONE, not even an Admin, can see the content I have created unless I have shared the content with them.
-
Status formula based on mult. conditions
How do I write a formula that would change a cell with drop down 3 tier symbols (Red, yellow, green) for the following. This would be in sheet summary - if all priority items are on time, its green. if only one is behind, its yellow, and if two or more are behind ,the project is red status Green: IF [Priority] is checked,…
-
Automation - Alert based on Date change in a column
I have a sheet with 2 dates, original ship date and current ship date. I want to send an alert when the ship date changes, but not when the info is entered for the first time. Or, to not send an alert if the ship date is the same as the original ship date. In the conditions, I can't seem to find a way to do this
-
new user here! tracking system question
I have a person creating Eloqua emails upon request. The requester fills a form with instructions and attachments of the email body. The email body will be sent back and forth for edits between the requester and the person creating the email on Eloqua. Is there a way to track the edits and keep them all in one request? I…
-
Automatic Export to Google Sheet?
Hi! Is there an option to automatically export to a google sheet? I know you can set up a recurring email w/ attachment, but was curious if there was similar capabilities via the export function. Thanks!
-
Subtract List Of Parts from Inventory
Hi, I have a Inventory Sheet with list of items and also the quantity of each item. I also have products that use various items from the Inventory list, which I list in the "Products parts list", for example: Product #1 requirements = 2 Wheels, 1 axle, and 2 wires. And the way I have set it up now, every time when I sell…
-
Parent row not showing for user
Hi all, A person shared to a sheet (access level Editor - cannot share) is not seeing a parent row: What it should look like: What it looks like for this particular user:
-
Workaround for resource leveling or displaying resource constraints w/o resources enabled
Working in small company, so we dont' have ability to purchase 10000 or have every resource assigned projects be SS users...is there any sort of workaround that could present similar picture?
-
cell reference on dashboard
I have a dashboard that references a cell in a sheet. That cell contains a formula that displays a value based on date triggers (future, open, past due). My problem is the cell value will only update if I open the sheet and then click save. Is there a way to do this so I don't have to open the sheet everyday? Its a…
-
Contact List Update Automation
I have a selection dropdown for a Contact List in a form. Is there a way to automatically update that dropdown contact list rather than manually adding and removing people as they leave or join my organization? I want to try to update contact lists and contact list dropdowns in forms across all my smartsheet templates. At…
