Hi All, Currently I'm trying to make my RYGB column give the right color light when it meets certain criteria. This must be based on a Start Date column, End Date column and a status column, but I can't seem to figure out a formula that works. So the way it should work is like below: Is there anyone who might know a…
Hi, I am trying to extract the first and last name from an email address with the names in proper form (first letter capitalized). Is there a formula to do that? Here is an example of what I'm trying to do.
This discussion has been merged.
A group I am supporting would like to have a multiple contact "Assigned to" column for each task. However, the issue is that they want each person in this cell to be able to report different hours for that task, so a single task needs to collect the hours worked by all people assigned to it. Is there a way to do this…
Hi, Not sure if this is possible but I thought I'd ask in case anyone has a creative workaround. I have a scenario where I want to send certain columns from one sheet to another. I'm able to do this using a checkbox and Zapier that does the heavy lifting. However, I'd love for there to be a way to bring up a form when a…
It would be great if we could have a 'Hidden' checkbox attribute added to the Column definition in Sheets (with Name, Column Type, etc.). In many cases when we have Sheets with multiple helper columns that we would rather be hidden, I find that it is a time-consuming task to re-select the same columns to hide again after…
Automation option that will list the cell history in a similar format that is available with the cell view history.
The ability to copy an existing sheet summary field and edit to save with modified formula.
Howdy! I am new to smart sheet, and have the programming knowledge of a 1st grader :-) I am attempting to write a formula that returns a specified value IF it finds ANY of the specified values in a cell (that's within the same row). I also want to know if the cell is NULL or if ANY of the values are NOT found. For example:…
I'm challenge by this situation and the only way I have worked out how to do it is to use the mouse to click into another cell. What happens is, after I have made a selection of one or more options from a drop-down list, the following keyboard commands result in undesirable effects: Tab or Enter while mouse is hovering…