-
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ā¦
-
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ā¦
-
Archived Community Post: Why am I asked to log in to Smartsheet to use Community?
Hello, I am wondering why I am asked to log into Smartsheet if I have clicked on Help from my Smartsheet window? Shouldn't Smartsheet know I am logged in since I accessed it from my already logged into Smartsheet? Thanks!
-
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
-
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ā¦
-
Doing things first time right with data validation
In a productive organization, the most efficient method for cutting waste is to attack anything and everything that is not done right the first time. The only drawback to SmartSheet is its ability to manage "data validation" like excel does. Even with column properties set as Date, users can still write stories "textā¦
-
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ā¦
-
Feature Request - Comments and Attachments trigger 'modified' column value
I'm trying to create reports that will show my projects the changes to their workspaces over the past day. I thought a report would do the trick, and I'd just filter by modified within the last day. However, reports don't always catch what you're looking for, like ALL the changes. Report WARNING, the "modified" systemā¦