-
Conditional Formatting
I am trying to setup conditional formatting for a cell if it does NOT contain certain text. There is an option for contains, but not the other way around. Ideas for a solution or go around? Thanks!
-
Force choice between columns
I tried searching the boards, but not sure that I'm asking the question the right way. Essentially, I'm looking to know the following: Within the Smartsheet worksheet, I have two columns both set up in a checkbox format. I'd like to restrict my users from checking both accidentally as it should be an either/or scenario.…
-
clone questions
Hi, I want to "clone" the following items from one sheet to multiple other sheets. I don't want to manually redo everything. Is there a way to do it: 1. Clone a workflow: I set up a workflow in one sheet (trigger is a date). Can I "push" this to the other sheets with the same structure? 2. Clone a Conditional Formatting:…
-
Graphing Data
Hello All, I am trying to build a graph of data and I was hoping someone had some ideas for me. Scenario: Multiple locations use a form to input data on incidents that occur at their location. The form has them input incident type (from a dropdown list), time of day (from a dropdown list), their location (from a dropdown…
-
Workflow for multiple column
Hi, i am trying to create a workflow for more than one column. I want to use the same exact condition for multiple column at the time. I have over 20 column so it would be long to create 20 workflow that basically do the same thing. Is that possible? Same problem with conditionnal formating. Thanks for your help.
-
Set default text for a given cell
I am creating a template and would like certain cells to give an example or show what type of information should be entered. The default text should be in that cell always unless other text is entered in. If the newly entered text is deleted, the default text would show up again. In doing some research, this type of field…
-
Subcontractor needs Help
We are new to smartsheet and looking for advice on the best templates to use to track schedules, and being able to track delays, etc. Would anyone be willing to share ideas or sheets that you have found useful to your business? Thank you! Sarah Link
-
Inconsistent Date Options
Hi I recently came across 2 date-related options which look inconsistent within the app. Would be grateful if the smartsheet development team can address it soonest! The Inconsistency: In the Workflow-Automation we can set a Condition as <any date field> is not today; whereas in the Conditional Formatting dialog, we don't…
-
Nested If with Multiple Check Box to Status Type
I was hoping I could get some help here. So I've decided to create a status for each of the tasks my employee is working on. Categories include: Done On Deck In Progress Not Started There is a checkbox column for each category. IF([Done]@row=1,"Done" IF([On Deck]@row=1, "On Deck" IF([In Progress]@row=1, "In Progress"…
-
How to keep cell unchanged in status column
Hi, I'd like to do the following IF([Done]@row=1,"Complete),IF([Target Date]@row<14, "On Deck",<leave unchanged>) Is the whole concept of leave unchanged an option? Because I'd like to keep the default that a person selected as the status, unless it's for an item that's complete as indicated by the checkbox in Done, or…
