-
Few questions about Smartsheet
Hello, I'm new to Smartsheet and created a trial account to test if we can automate our resource management process with it. I have the following questions about Smartsheet. 1. With Alerts & Notifications I want to create rules to send notifications or approvals to project managers, team managers and project members. Is it…
-
Company uses smart sheet in metro manila philippines
Hi is there any company here uses smartsheet in philippines specially in metro manila? may i know the company name thank you
-
Removing duplicate types in an output report
I have a report that shows the output of staff within a department. It shows all the publications and events they are working on. I am looking to build the report so that it does not show duplicates of the same type of output by the same person. For example, Staff member A is running 10 roadshow events throughout the year.…
-
Why doesn't my mouse wheel work within a sheet?
Scrolling through a big sheet with the wheel on my mouse would be great. The scroll wheel works in every other thing I do - including parts of Smartsheet- just doesn't work within a sheet. I've changed settings on my mouse but still does not allow me to scroll within a sheet- forces me to grab the slider on the side or…
-
Remove User from Enterprise Level
Good morning, In the Team level, I had access to a report that showed me all Users per sheet/report, so that when someone left/changed departments, I could easily see what access they had. This report is no longer available to me since we went to the Enterprise level, and our SysAdmin says that the report only shows them…
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
How to hide rows on a list?
Hello everyone, I am on the trial version, testing to see if it will work for my company. I loaded a spreadsheet from Google Sheet, and I am trying to hide some rows. I clicked everywhere and wasn't able to find. Would somebody please help me? Super thanks in advance!
-
Time tracking for Collaborators
Hello If I set up time tracking in a sheet, can that be accessed/used by free collaborators? Thanks Megan
-
Block non-working days for resources?
Hello! I'm trying to schedule around vacation dates and other non-working days per resource, not for the whole team or whole sheet. How can I block off non-working days for a particular person without doing it 'manually' and messing up the dependencies? Thanks for any guidance!
-
Multiple, comma separated values in one cell
Hi I'd like to create a report which returns all rows that have a certain value in column 'Donors' - i.e. we have activities that are funded by one or multiple donors, and I'd like to return all activities that are funded by Donor X. Conference one - donor x, y, z Conference two - donor y, z Three - donor x And the report…