Not sure if this is possible, but I would a row to become hidden based upon the status of a drop down. If cell is blank, nothing needs to happen. If cell is "delete" or "archive", I would like the row to become hidden. Any help would be awesome.
我read in an older post the when using forms you can only use values within the drop down even when "restrict to dropdown values only" is not selected. Has this been resolved yet by Smartsheet?
我想创建一个警告。我f a cell turns red in a delivery date column, email PM assigned to PM column and another editor within the sheet. Do not see how to establish an alert just based on change of color.
我need to do the combination of formatting with and alert, but seem to have hit a wall. If column "delivery type"= selection "o" and column "1st delivery" has a date that is past due then turn "1st delivery" to red and send an alert to the contact in columns "PM" and a particular individual. Any help would be appreciated.
