I'm trying to set the RYG status of a task based on End Date and % Complete of the task.  I've put a formula in place using =IF(AND(...  but I keep getting the error "# INCOMPLETE ARGUMENT SET"

Below is the formula, can anyone tell me what I'm doing wrong or missing, please....




A Viewer has little reason to need to see a formula in a column that is being displayed to them in a Report.

Please remove the hover for the Formula (the other hover that displays the full contents (display value) of the cell is OK, just hide the formulas.

Or tell me why this is a good feature.


Use Case:

I have Sheet with lots of columns. Lots. 100 or more.

I have a Report designed for a specific role and task set.

The Report has a few columns. Two or more but less than 10. Limited view of the data.

On the Row Menu, there is an Edit option that allows the user to see the Row in vertical


When creating a link to a URL, for example in a Dashboard shortcut widget, please allow us to copy and paste from a valid hyperlink, even if that hyperlink is only in a cell in Smartsheet.

Use Case:

I create a hyperlink to the Form

1. Open Sheet.

2. Open Forms

3. Copy URL of desired Form

4. Open