Brand new to SmartSheet. Looking for best method for nested IF/THEN statements to provide status. Or alternate methods. Example... IF column N has any value, THEN column B shows Status 1, IF column O has any value, THEN column B shows Status 2, etc. My nested IF/THEN statement from Excel didn't
See screenshot. When I indent my headers, the expand/minimize button is all the way to the right (circled in red). I would like it to be in the cell with the header label. I cannot figure out why it keeps putting it all the way at the end.
Second- When I try to do additional indenting below that
I'm terrible with formulas! What would my formula look like to do the following:
I have a listing of open action items, each with an attached target due date. I need the RYG overall project status balls to update automatically. Green if no action items are past due, according to the target date