Notification when comments change
I am trying to get automaically notified when someone adds a comment in the System comments column (circled in green). Thoughts?
I was wondering if there is a way to apply conditional formatting on a cell based on the outcome of another cell. For instance, I have a % Complete Calculated column and a % Complete Actual column. Is there a way to change a cell in the % Complete Actual column yellow if it is less than the % Complete Calculated?
Can I reference the workspace in a sheet or report?
I have a report that compiles data from multiple Workspaces. I would like to be able to include the workspace in the report as a column (just like I can include Sheet Name as a column.) Is there at least a formula that I can include in a sheet that returns the name of its workspace? e.g like =WORKSPACE() ..?
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…
Need a drop down list to populate it's selection based on the selection from another drop down in th
I am creating a survey sheet and forms. I have created two drop down lists in my sheet (easy enough). One holds 5 selections for neighborhoods in NYC. The second column conains addresses all over the city, all found in one of the 5 neighborhoods. I would like to be able to select a neighborhood from column 1 and then have…
Feature Request: Ability to @ someone and they get notified
I would love the ability to be able to @ someone when making a comment, and then they get notified in and email that I mentioned them. This would really help when I am making comments and I want people in my team to see that comment (without having to use the notifications feature because it isn't that great because it is…
Card View is great for sheets. Please bring to reports, too.
Love Card View! I can definitely see using it. My issue is that I do almost all of my viewing in Reports as opposed to Sheets because I work across many sheets for my work, consildated into Report views. I know there might be complications to implementing this, for example when a sheet included in report does not have a…
Colouring Cells using a formula.
Hi, I am trying to colour cells depending on the data in cells to show a status. below is the statement so far but cant get it to work correctly. any help would be great. =IF(AND(TODAY() > Start166, [% Complete]166 = 0), "RED", IF(AND(TODAY() > Finish166, [% Complete]166 > 100), "RED", IF(TODAY() < Start166, "WHITE",…
Check Box Column Property Not Working
I feel silly asking such a basic question, but it's got me stumped. Normally, under Column Properties, when I select Check Box, a box appears in the column as it should. However, no matter how many times I've tried, no boxes appear. It seems to remain as a Text/Number. Has anyone run into this? Thanks!
Formula help predecessor
I need a formula for If there is a predecessor the status of predecessor is complete (other row) than show "start" If there is NO predecessor show "start" How can I make this? Name of columns: Predecessor: Voorafgaande taak Status: Voltooid THANKS!