-
If cell is not blank, checkbox
Hi, I would like a formula in column1 that says, if column2 is not blank (meaning it has ANY text in it), check the box in column1. Any ideas? thanks!
-
Creating a formula that relies on conditional formatting
Hello all. This may be out there, but I am not really sure what search words to use, so haven't had much luck in seeing if anyone else has come up with a solution. I am trying to create a formula that will calculate the sum of all cells in a column that meet a specific format, in this case, shading. I do not want to have…
-
LOOKUP documentation mismatch
The formula documentation: http://help.smartsheet.com/articles/775363-using-formulas gives these as the arguments: LOOKUP(value, collection, return_column_index, collection_match) while the Template for Formula examples gives these arguments: LOOKUP(lookup_value, lookup_range, return_column_index, range_lookup) The fourth…
-
Feedback Requested: Using Formulas Article
Hello Community! We just made changes to the "Using Formulas" article in our Help Center that we’d like your input on. A few of the modifications include: * Alphabetizing the list of available functions. * Extensive function argument definitions. * Up-to-date list of error messages. We hope you’ll find that this makes the…
-
Parent Date Roll Up
I currently have a sheet where i have multiple columns with dates thats that are going to need to roll up to the project level parent. I am looking for a way to roll the dates without using the predcessor function as it doesnt quite work right. In the picture below you can see some of the columns. I would like to have the…
-
COUNTIF Formula Help
Set up a set of columns: lead, support and stage. I can get the COUNTIF formula to work for me to count the names of the people assigned in the lead and support columns, but I need help figuring out how to get it to also look at the stage column and NOT count that name if the cell in that column says CLOSED. This is the…
-
If Statements and Calculations
I'm trying to calculate a cost based on whether a field is marked (and another field that contains quantity) or not. So, if field A is marked (checkbox), then multiply $5 x Field B. If field A is not marked, then multiply $4 x Field B. Is there a formula for this? Thank you, Jennifer
-
Formula to change a cell's value if date is in the past and another column's value is not a certain
Hello there, this is my first discussion and I have a feeling this might not be possible, hehe. I would like the Status (a dropdown list column) to change to a certain value ("Complete") if the Date (a date column) is in the past and the Type (a dropdown list) is not a certain value ("On Campus"). Thank you so much!
-
Formula Malfunction!
Has anyone every had a situation where a formula in a cell calculates improperly if it references a cell whose value is also derived based on a formula? I have a formula set up where it's looking at cells in the current and previous rows to calculate total hours worked in a day. (I borrowed this formula from one of you…
-
Feature Request: Timesheets / Time Columns / Time Trending
What we want, is to be able to generate a daily or weekly report of how much time each person worked, and on which tasks. We need to be able to not only see the efficiency of the tasks, but also of the people. And if we can select a specific period of time, this would also be useful. I have a project where each row has a…
