-
Update request missing option to change end dates
Hello, I'm a rookie to smartsheet and PM work. I have sent out my update requests and my partners on the receiving end are telling me they cannot update the end date field. They are able to edit every other field. Can you help? Does it have something to do with changing the end date of the parent row first? Thanks! Monica
-
Does the autofill formula feature not work on project sheets?
When I create a blank sheet to test the autofill formula feature, it works well. However, it does not seem to be working on my sheets that are project sheets. Anyone have any insight on this?' TIA
-
Does Login History track login via a sheet URL?
Apologies for a very basic question but would like to be 100% sure. If a user with an account accesses a sheet via the Edit URL for that sheet, will they show up in the login history? I'm guessing they WON'T but as I say, just want to be fully sure. We have a lot of users who started off accessing the odd sheet via a…
-
How can I calculate the percentage a resource is allocated to each project?
How can I calculate the number of days or allocation percentage a resource is assigned to a project? What I'm trying to understand is the percentage a resource is allocated to a project so I can track the total in a master project list. For example, if a resource is assigned to 3 projects and they are aloocated 25% per…
-
Feature Request - History view
Ok, so it's nice to be able to see how things are trending, but given that things keep changing it means you need to have to keep old reports or backups around that you can plug into excel. Wait though, we have the history of each cell available within two clicks. And we have the highlight feature which shows which cells…
-
cc for update request
Hey SS folks, I would like to see the option to have a CC list for an update request. I work with remote teams that have onsite managers, and while I do most of the update requests to the team for corrections or omissions - the manager needs to have visibility of the update request so that they can keep the local team in…
-
Comment notifications
Hi SS Guru's i've received the attached email informing me that a colleague has made a comment on rows 1210 in our SS titled 'NPD Tracker'. When I click the only hyperlink I want to go to Harry's comment, but i am instead directed to the SS and not the specific row. is there something that we should be doing differently so…
-
Notifications
Is there a way to personalize at what time of day to receive notifications versus geting them at midnight everyday?
-
managing projects and access to information
Hi there, We are using smartsheet for the first time to run a major project over 8 months long. We have set it up with all the weight points etc, we have users allocated including the project manager, the technical manager and the client - who wants to see it to keep an eye on the project. I now want the PM to keep…
-
MAX(range)
Finding the maximum value over a range is a simple matter given Smartsheets formula. How does one filter the data in the range? That is, find the maximum value of the data in a column given, in my case, two conditions. If the row contains column cells where these conditions are true, then include the data in those rows for…