-
Settings for Checkbox Column
How do you change the setting for the checkbox column? I want the whole task to be crossed out if the checkbox is checked as done. I copied this from an old Smartsheet account and that setting didn't carry over. Thank you!
-
Rolling up Conditional Formatting
Smartsheet Community, I have a normal project in which we have tasks that sometimes go past due. Currently I have conditional formatting set such that if the task is not 100%, and the due date is in the past, that whole task row turns red. My question is how do i get that past due task (red) to filter up and make the…
-
Conditional Formatting Based on 2 Different Cells
I have done this in Excel but can’t seem to get it to work in SS. I need conditional formatting to represent the following: EAC Margin < BL Margin BL Margin ≤ EAC Margin ≥ (BL Margin + 5%) (BL Margin +5%) < EAC Margin Tried creating a separate column with a formula using IF. But can’t seem to get the formula to work. I am…
-
Using AND and ISBLANK in nested IF statement
I am responsible for tracking my companies incoming inquires and quotes. Did we get back to everyone, quote them, did they accept or decline the quote?, etc. As part of that I sweated out the following formula, =IF(ISBLANK([Follow Up Date]98), IF((TODAY() - Created98) - 2 > 0, IF(OR([Quote Accepted]98, [Quote Rejected]98,…
-
Time stamped entries
Hi All, Is there a way to create a column with time stamp entries like the comments section? I want to make a highly visible column of entries that show when the entries were made. Right now the comments column can not be renamed or even copied. Regards Tony
-
Lead time Formula
Hello, I'm trying to figure out a formula or a way to make 2 cells work together and have the results in a third one. Here is the situation. this sheet is for procurement of items and their lead time to order. Example: in one cell we would put the date we would like the item to arrive onsite and in another cell we would…
-
API to apply conditional formatting
I am not able to find how to apply condiional formatting via API. I have various sheets that I want to update all at once and apply different conditional formatting without having to do it via the interface manually.
-
Conditional Formatting Key or Legend
We use conditional formatting for our master training calendar to show which training is for which audience. I have been asked to provide a "key" that shows what each of the colors represents on the calendar, but I haven't been able to find an easy way to do this. Any ideas are welcome and appreciated!
-
New Feature Request for Coments
It would be helpful if there was a way to flag a comment as complete. I would like to see a way to turn the Comment box for a row green (or any color) if the Comment has been completed or resolved. This feature would be very helpful for me to see quickly which rows or Comments needed to still be addressed. I am a very…
-
Apply Conditional Formatting to a Workspace
Is there a way to apply conditional formatting to an entire workspace, when sheets are identical in set-up, column type and layout? Thanks