-
Maintaining a list of small department's resources
My compny is small (about 15-20 resources with limited turnover). To allow all users to work` w1ith the same list of resources as I undestand it, because contact lists are not shared, each user (or maybe just PM) would need to create (or import) a list of names/emails that would then be available to assign to tasks using…
-
Backups
Hi there, We realized yesterday that the backups that are saved are only done on the weekends. We went in to stored backups and almost opened a file but we were afraid that if we opened the backup then it would override the work that had been done today and would erase all changes that had taken place since the last…
-
Cant remove someone from a sheet / workspace
When I try to remove someone I have shared a sheet / workspace with.. it says I have reached the maximum number of sheets for my account (I have not) and I can't remove the person from the sharing. Can anyone help with this? I have got a new assistant and I need to remove the old one.
-
How to remain logged in on mobile device
I find it frustrating that I have to re-authenticate everytime I pull out my phone on a project to check dates. Why can't SmartSheet remain logged in just like all my other apps?? Is there something I'm missing? I've done a search but don't find any threads on this problem. Andy
-
Setup weekly Reminder till task is "Complete" - Reg.,
Hello All, I have a set of tasks which i requested my team to update once a week. In order to remind them, i want to setup reminders so that they receive email once a week. I saw someone telling to create report and setup reminders. But, i could not figure it out. Request for help here. Thanks & Regards Srinivas Poosarla
-
Workspace Project Tabs
I have searched and cannot find the answer to my question. I have several project tabs open but when I switch from one to another, it last tab will arbitrarily change to a different project from my Sheets list. (I have marked some as favorites hoping this would keep them open but it doesn't.) I then have to go to my Sheets…
-
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
-
Webform vs Request Form
I really like the Webform feature. It's made things easier with coordination and data entry. Could I also upvote a feature for Request Form (as an extra step)? It would nice if the submitted Webform goes directly to the sheet administrator first to approve before it goes to a sheet directly. Not because it's been submitted…
-
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…
-
Due Date is Past Due - Checkbox
I'm trying to write a formula that will "check" the checkbox if the Adj End Date is Past Due and the % complete is not 100%) I started with just the Adj End Date portion and have not added the percent complete to the formula. This isn't working... =(IF(TODAY() > [Adj End Date]5,TRUE,FALSE) I then want to do conditional…