-
Ability to use differnt font colors in a cell
Would anyone else find it useful to be able to use use different font color for certain words in a cell only, rather than having to change the font color of the entire cell? The ability might also be nice to be able to underline and italicize certain words in a cell as well but definitely colored font to call out…
-
Automating Grey Ball
I am having an issue getting the grey ball to work when a task has been marked done. The formula that i have is below. If will only work if the date is older than today. If will change the balls to other colors depending on the dates even if the task is marked done. Any suggestions? =IF(AND([Due Date]1 < TODAY(), Done1 =…
-
Customized Sheet Properties
I have a situation where our organization will be creating all of our project sheets through one group. This means that the project owners will be out of sync from who actually is the owner. In addition to this we would like to filter by certain project level items such as Implementation Status, Project Health, Escalation,…
-
Automating Balls
I have a formula that works for some of the functionality. I am having an issue getting the gray ball to work using this formula. =IF(AND(TODAY() - [End Date]4 > 0, [% Complete]4 < 1), "Red", IF([End Date]4 - TODAY() < 4, IF([% Complete]4 >= 0.9, "Green", IF([% Complete]4 > 0.5, "Yellow", "Red", IF(AND([End Date]4 <=…
-
SumIf across SmartSheets
Is there a way to create a sumif formula that references cells on a different sheet. If I'm entering the formula on worksheet2 but suming values from worksheet1 column2 if worksheet1 column1 values match worksheet2 comlumn5 values. Example: =Sumif(sheet1!column1:column1,column5,sheet1!column2:column2) I can't figure out,…
-
Date option in column properties
It would be useful to be able to scroll through years as well as months for delivery dates more than months ahead
-
Smartsheet Access.
My colleague cannot access a spreadsheet, she has sharing rights, but keeps getting the error message "this item is not currently available, it may have been deleted or your permission may have been removed from it". I have removed and re-added and she still is getting the same message. Can you help? Thanks. Karen.
-
Recurring Tasks Set Up
Is there a way to set up a task that happens every quarter or six months without having to enter the task 4 times in each year?
-
Feature Request: Configurable title of the comment email posts
Feature Request: The title of the comment email posts should be configurable (Including Taskname, etc)
-
Feature request: Ability to use "Me" in reports
Hi Team, I think this would be an incredibly useful development that should be blindingly simple to implement - to allow reports to be created and filtered based on "Me" from a contact list column. This would simply take the loggeed on user's name, whoever that happened to be, rather than selecitng a specific contact from…