Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2016 Posts
Archives for September 2016
Discussion List
Nested IF/AND Formula
Hello I am trying to create a matrix using the IF/AND Formula. So far the first part of the formula works which is this: =IF(AND(Probability1 = "Low", Impact1 = "Low"), "Low", IF(Impact1 = "Medium", "Low", IF(Impact1 = "High", "Medium") Now I want to add the other combinations ((Probability1 = "Medium", Impact1 = "Low"),…
Durations Not Adding Up
Some of my durations are not adding up.
Freezing Columns
What is the trick to freezing more than one column? I have done one but when I try to freeze a second one it seems to eliminate the first one I did. Any suggestions? Thank you!
Entering date format similarly to MS Project
Hi all. looking for advice on how to potentialyl change the date that apepars in the start and end date column formats from xx/xx/xx to (for example) Wed xx/xx/xx. Is there a setting that allows you to change this? Not being able to see the day of the week is a bit of a challenge when putting together plans that have day…
Falling behind on Project Actions
Dear fellow Smarters... is there a way that an auto email alert can be sent out to the 'asigned to' person that has been triggered when a deadline has passed (or is maybe approaching) and when the % Complete column is less than 100% Complete. I think i can set up a Report to do something although isn't a Report only sent…
Enter in Chinese New Year
I have a project that has partners in China. I want my gantt chart and certain tasks to work around their Chinese New Year from end of Jan to middle of February, so it reflects that the Chinese will not be working on the project. How would I do that?
gazzilion emails received!
okay, so not a gazzilion,more like 23, but still 22 emails more than I'd ideally like. I sent a note out via the email function to three groups of people and CC'd myself and in retrun received a CC for every mail sent to every person. Is there a way that I can only get one CC please? Si.
Automate Value Recording
All, I am trying to setup a PMO dashboard where I am putting Total Portfolio Value graph. I have to update the graph fortnightly to record current value. Is there anyway to automate this function so that everytime I dont have to manually enter value.
Feature-Request: Prevent overwriting in multi user environment / Lock cells
Hi, There is a big problem with multiple users working on the same sheet. We lost several times the work of each other. Other online tools lock the cell currently under work (like google sheets). I know you have a workaround for this problem: https://community.smartsheet.com/discussion/overwriting-changes-multiple-users…
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…