Trending in Formulas and Functions
-
How to update a status color
Hi, My goal is to have the status change from blank to yellow once an agent name is added in column 3. How do I do that? Any help would be greatly appreciated! Thank you!
-
COUNTIF/S Sheet 2 has "Auto Doors" in dropdown
Hello! New to Smartsheet and trying to get a ticketing system going for our FY 2024. I've done a Form already and am working on a metrics sheet for a Dashboard. This is all VERY new to me and I've had no training but I got a subscription and trying to make the best of it. I have Sheet 1 where the Form responses go to. I…
-
Combining selected cells into one cell ignoring blanks?
Hello all, I am trying to combine cell into one cell and I have found a couple other community posts covering this issue. The only problem is that their solution only applies if you are trying to collect the entire row, I need specific row. Originally, I did this just by using JOIN and then selecting each cell, separated…