-
Sheet Timeout & Performance Issues – Identical Copy Works Fine, Original Doesn’t
Hi everyone, I’m currently working with a Smartsheet that includes: ~30 conditional formatting rules ~1700 rows Multiple columns with INDEX/MATCH formulas Numerous columns with regular @cell formulas Numerous columns with various types of data Two Data Shuttle workflows that update dropdown values in two columns Multiple…
-
Conditional formatting randomly not working
I am trying to determine why the conditional formatting has stopped being applied to random cells. I have the settings set to change as we change the drop down option. However there are random cells that the background formating is not applied and you see the words. It is random. I have cleared formating. Deleted the…
-
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…
-
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?