-
Change formatting based on new date input
Background Currently, I am tracking whether a person attended a visit on a certain date and color coding for easy reference. Each row represents a person These dates are at regular intervals, so I'm using a column formula to calculate what the dates should with each each column referencing the column before it as long as…
-
Change Formatting in Reports
It would be very convenient to be able to format a report different than the sheet. One purpose of a report is to bring multiple sheets of data together, but often those different sheets have different formatting which can make your report look awful. If you could format your report at the report level, it would solve all…
-
How do I get my datasheet to show the months requests were opened and closed
when my request tracker sheet's input is in calendar format? Current set up is as below, and I'd only like to use data from column A & B to ensure better accuracy in the data sheet:
-
Combine "AND and "OR" with filtering
I did not see this topic covered: Is there a way to combine logical "AND" and "OR" when creating a filter? The only options seems to be 'All conditions" (AND) or "One of the conditions" (OR) Here is why I am asking: I want to filter a buzzword that some people put in the "Comments" field and others put in the "Suggestions"…
-
Conditional Formatting for Proof Approvals
Would be great if once all parties have approved a proof (using the built in proof approval feature), conditional formatting can be applied to a row. This way we don't have to go in and manually check the status on who has approved each line item. I haven't found a way to do this and have viewed a lot of forums. If anyone…
-
Hyperlink Color on Dark Background
Hi, I'm new to SmartSheet so I may have missed something. When I add an hyperlink on a cell with dark background, is there a way to make the text white or any other color that would allow to read it? I thought the automatic mode would change the color, but it does not let me do so... any ideas? Do I have to stick with…
-
Date & Timestamp a specific cell change
Hello, I am very new to Smartsheet and I am working on a project tracking sheet. We have the following statuses in a cell: Unassigned; In Progress; Completed; Cancelled; On Hold When a request is submitted this automatically triggers a 'Created Date' column that logs the date/time of creation. I would like this to be…
-
Conditional Formating
I have a column where multiple values can be selected. When "A" is selected certain other columns are blacked out. I want to have a rule that when "B" is also selected a few of those columns that were previously blacked out become normal again. However, when I try to create the rule for "B" it removes the rest of the…
-
Formula help to convert from total days to business days
I have this formula which gives me the total # of days to complete a construction interval, =IF(NOT(ISBLANK([Construction in Progress Date]@row)), ([Into Pending Lateral Date]@row - [Construction in Progress Date]@row)) How can I convert this to business/work days total?
-
Show % progress on bars in Gannt view
Been searching and can not find any clear answer to this so ill ask (maybe again). Is there a way of presenting the % progress within the bar of a task in Gannt view as it is as default in MS Project for example? It could be enough to have it in 25,50,75,100% increments for me