-
Admin Report - Sheet Tracker
Is there a report or query that can be done from the Admin account that shows all the sheets created in our cloud instance. I see that there is a total like 363 out of 500 sheets used, but it doesn't show date, who, sheet name and current status of that sheet (archived, deleted, new, etc). Is this possible?
-
URGENT help on Master plan roll views
Dear All, A bit of a funny help but can anyone share the view of how their master plan gnatt chart. In my consolidated plan i inserted a column with a checkbox to see which rows should be presented in the gnatt chart. However my program manager wants to see the inter-dependency link too. and I was wondering if I am doing…
-
Tool bar Fix Needed
Seeing large numbers of users and multiple threads frustrated over the movement of the toolbar from the side to top and loss of "tabs" vs individual windows in browser with last update. How soon will there be a sheet properties adjustment allowing individuals to choose a "view" that allows us to move back to what worked…
-
Formating for dates past
I'm looking to set a rule for when my 'Finish' date column pass my 'Completion' date column. When I try to set the rule it only allows me set when passes a fixed date rather that a date set in a certain column? any help welcome. thanks G
-
Setting up a Notification to send to myself
Hi, I have an issue with Smartsheet and I'm not sure if I'm doing something wrong. I'm setting up a notification through the Alerts and Actions. I want to Smartsheet to send me a notification when one of my users updates a Row to tell me that an Order is being despatched. In the Delivery Settings, I have Shared user or…
-
Can calendar view default to current month when a sheet is opened?
It seems there'd be a way to do this but I haven't figured it out if there is. I have a calendar that displays important dates from linked cells in another sheet. I set it to default to the calendar view but every time it opens it displays June 2017 even though it's currently April 2018! I'm guessing it's drawing from the…
-
Notifications not working for 1 user
Hi there, I have an automatic notification set up to email the contact listed in a column once a day when the RAG status changes to red. This seems to be working so far for other contacts except for one individual. Any ideas what might be wrong? I made sure that the sheet was shared to the person, and that their contact…
-
Change in Status column effects Assigned to Column
I have a series of approvals that are being managed through smartsheets. There are many more status conditions and only a few people on the team. I would like to have my Status drop down options correlate to the Assigned To column. Is this possible? I feel like it could be done, but I haven't been able to figure it out.
-
Exactly Duplicating an existing SHEET to a new sheet
I have a sheet which records my orders as in attached. I want to make the NEW sheet with the exact same headings so I can remove the completed order from the Sheet #1 and move it to sheet #2 ( new) . Michael Ahmed michael@libertycards.com 817 937 5046 cell
-
IF formulas
Hi, Tried looking for my question hoping it was already answered, loving how Smartsheet community works. I'm new to Smartsheet and need help with an IF formula. My company has several titles (positions). In the Title column there is a drop down menu for 5 Titles. In another column, I have their Rounded Hours for per line.…
