-
Formula return blank result
I've attempted multiple times to create a function that result in Blue, Yellow, Green, Red health and it has been unsuccessful. Here are the results that I am aiming at: On Track > "Complete" "In Progress" = Green Ahead > "Complete" = Green Ahead > "In Progress" = Blue At Risk > "Not Started" "In Progress" = Red Behind >…
-
can smartsheet support "comments" and “cell merge”？
Hello, I am wondering whether smartsheet can support "comments" and “cell merge”？ -Cell comments: Write a comments for the value in the cell, like excel? - Cell merge: merge the adjacent cells as one cell - Two level columns headers: Ex: Level 1: Jan Level 2: Qty, Amount, Price Now I can only write header as: Jan qty, Jan…
-
Using formulas to copy, or transfer data between cells.
Hello community! I am looking for a seemingly easy solution which I can't find. While the workflow automation helps in many ways, the "actions" available seem to be greatly lacking. For example in google sheets + scripts + triggers, I can have a cell update based on a formula from a time driven event (whether external or…
-
Read receipt
Good Morning, Is there a way that if I @someone on my smartsheet and it sends them an email that I can be notified when they click the link and look at the smartsheet?
-
Filter / Work flow
I wanted to create a filter or workflow based on a comment added within a certain data range. What I am trying to accomplish. - I need a filter or a workflow based on a no comment being added to a line within a data range. So if a person does not add a comment to a line between Monday and Friday. I can filter or report on…
-
Limiting what customers can and cannot see for projects
We use smartsheets to run our customer projects. The approach we have used to date is to create a workspace for each customer, with the necessary sheets - all from a template. This works really well, as the customers need to review and contribute to several of the sheets that we use, and the workspace sharing feature lets…
-
show last comment in Cell
is there any way to define command for cell to see the last comment in the cell it will improve the tracking Tasks , to see in front the last comment in the SS and not go enter to the comment in advance … to enter the comment in cell and log it direct to the comment log\screen
-
Web Form Feature Request
It would be helpful to have the ability to add a comment field to a webform and have the comment go directly to the comments for that row. Currently, we have a comment column, but the comments can be long and if you do a text wrap, it really creates a visual mess on the sheet and notifications. We also are required in many…
-
Reference in comments mail
When a comment is posted directed towards another user, the resulting email only mentions the row number. Is it possible to have a column value (eg. task title) as reference in the mail?
-
Do Not Include Comments in Export
I need to schedule an Excel file to auto send from a report to a client, but I do not want the Comments tab to be included. Is there a way around this? thanks,
