-
Merged: Report access should not depend on source sheet
This discussion has been merged.
-
Can multiple contacts in one cell report hours worked for a single task?
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…
-
Creative ways to show a form to a user
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…
-
Workflow - list historical values on cell(s) based on criteria
Automation option that will list the cell history in a similar format that is available with the cell view history.
-
Copy Sheet Summary Field on a Sheet
The ability to copy an existing sheet summary field and edit to save with modified formula.
-
Formula that combines Contains and OR to search for values in one cell
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:…
-
How do you use the keyboard to move to the next cell in a row after selecting items in a drop-down
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…
-
Help with a Rolling 12 Month Formula
Hello, thank you for taking the time to look at this and I appreciate any assistance anyone out there might be able to supply. I'm trying create a Rolling 12 Month Formula and running into an issue getting it to work. I have multiple programs on a sheet that have metrics and are nested under a blue header row. The data…
-
I cannot convert my if statement to a column formula
I have an if statement referencing another column named "Country" - I want to define this if statement into a Column Formula but it says "the column formula syntax isn't quite right". This is my IF statement. =IF(Country1 = "US", "01-440-0187 (US)", IF(Country1 = "Canada", "01-440-0188 (CA)", IF(Country1 = "Mexico",…
-
Form submissions
Is there any way to track forms that have been started, but not submitted?
