-
Using format and links in update requests and notifications
Hi dear Community, hope you all enjoy your weekend ? Do you know if it possible to give format to the text in the update requests or notifications f.e. bold, italic, underlined as well as putting URL-links to certain words or make quotations. This would be very important for me 😀
-
Conditional FormattingI
I have a column of dates with conditional formatting that turns the cell Red if the date does not fall on a Monday. This works fine. If the date is longer than 7 days in the past then I don't want the cell Red. I have a helper column that returns a '1' if the date in the cell is more than 7 days old. Now I want to add…
-
Cross Sheet Formula(s) w/ Yes, No, and Hold Decisions (IF & AND)
Hello All, I am trying to utilize a formula from a sheet (Parts Requests) to drive productivity and scheduling on another (Scheduling Board). I have created a formula [Report] to determine if the corresponding materials order has been received, on order, shipped, etc. which corresponds to a Yes, Hold, or No decision icon.…
-
Conditional Formatting Duplicates
Hello, Is there a way to conditionally format duplicates if a value is in a column and if a box is checked? I need this to look through the whole sheet where there are many input values by the customer via a form. Thank you. Brian
-
Auto Delete rows
HI, I would like to know please what will be the best way to delete rows which their time stamp i more than 24 hours. i can't find a delete function under the conditionl function.
-
Conditional Formatting Help
Hello, Can conditional formatting achieve what I'd like to do, and if so, how? I'm coming up short and would love help. I have a daily task list for projects I'm working on. I would like to have the row turn red if the due date is 3 days away and the status column shows anything other than Complete. Is this possible? Thank…
-
Is there a way to get custom color conditional formatting in smartheet?
-
Alert or update if a column value is changed based on the column(primary column)
Example - I've columns warehouse and route . I need to setup a notification or alert if the route had changed for a particular warehouse. In this example , I need to send notification or alert for Test and PR103 as the previous values of route has changed for them. can someone guide me as to how to do this?
-
COUNTING @ ROW LEVEL
Hello, I'm looking for a formula/solution that would count all the correct answers at a row level. If the answer is wrong then it wouldn't count it. Any suggestions? Maybe Conditional Formatting to denote wrong/right answers. Ive tried multiple formulas. I'm stuck. Please let me know if you have any additional questions!…
-
Conditional Formatting not applying consistently
I have a sheet with conditional formatting rules so that if there is a "0" in a cell the text will be gray and if there is a negative number it will be red. If I close the sheet and then open it again the conditional formatting does not show, but if I go into the setting and basically pretend to change the formatting it…