-
Date Last Updated?
Is there a formula I can use that would show the last date that a specific column was updated? For instance, when someone checks the checkbox column, could I have a formula in another column that would reflect the date the checkbox was checked? It wouldn't work to have a formula that showed when the entire row was last…
-
Baseline/Actual Schedule formula help
Hello all, I'm looking for some help with formulas in my schedule. With the schedule templet, I can insert the dates into the "start" and "finish" columns, the cells will auto populate. I would like to add two additional rows with "Actual Start" and "Actual Finish". When I enter dates into those rows, I'm looking for them…
-
Improvement Feedback on Conditional Formatting
Hi All Please read my feedback on Conditional Formatting. I need your vote on how valuable this change would be! FEEDBACK The conditional formatting should allow us to create a condition --using another existing cell's reference. Example: If "Fee Collected" is less than "Fee Due" then apply this format to "Fee Collected".…
-
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.