Trending in Smartsheet Basics
-
Formula help if statement but want to include if blank
I have a formula to say if a certain row contains a value then use another columns data instead. I want it to do the same if the cell is blank. This is what I have so far =IF(CustomerName@row = "NCR Intercompany", ServiceCustomerName@row, CustomerName@row)
-
Details Panel logic setup in Dynamic view not working
Hi, I am trying to add logic in details panel, to make few fields as read only, when Reviewed? column is "Reviewed". I'm not able to save this logic after I created. Am I doing anything wrong? Please help me 😐. Thank you!
-
Start date for alert - send on the last Wednesday of every month
Hello, I need to send an alert out the last Wednesday of every month. This is the easy part because I use the 'repeat' and 'repeat on' selection in a custom recurrence. My question is when to start: do I start on a last Wednesday? ie. start today 4/24? Or is the start date irrelevant, because the automation knows it should…