Trending in Smartsheet Basics
-
Can I make an IF reference in another sheet and then Index / Match?
Hi! I'm trying to make an IF formula that will look to see if a specific type of equipment is ordered, and if the PO has been issued, then move the checkbox to another sheet with Index / Match. Here's a simpler one without the IF... =IFERROR(INDEX({2024 GC and Contractor Sheet - Bids Range 1}, MATCH([WBS@row], {2024 GC and…
-
Sorting
Hi - We number tasks in our Smartsheet grid using the format XXX.X. When we sort in descending order, the numbers are not in order. For example 200.0 appears below 001.0. Since it is in descending order 200.0 should appear before 001.0. We also want to start using four digits before the decimal point and want to know if…
-
Set Note Column to auto size
I would like to have my note column auto size so that the note when longer then the cell it in, can be read in its full txt and not disappear under the next column