-
Formula HELP!
Hi! I am looking for a way to make my report of action items look better. I want to add a column that automatically can make my report look like the screenshot (attached). Does anyone know a formula that could help me? Thanks in advance!
-
Changing Drop Down Value Based On Current Date?
I am trying to change the drop down value on my Health column based on the current date. Is this possible? ie. If the start date value is in the past, the health column changes to "At Risk" which is one of the drop down choices.
-
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…
