-
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…
-
Rounding up the results of an IF formula
I finally figured out how to create an IF formula to get an AVG of Children divide that by a specific number, and enter "N/A" if there was nothing in the children cells. NOW my boss would like to Round the resulting number up to the next dollar value. Sometimes, I think she just likes to test me! LOL Here is the formula I…
-
Aging Items Based on TODAY
Hi, I'm trying to use the TODAY function to work out the age of an item. In Excel I would have a cell with =TODAY(), and do a calculation to subtract the date of the item from this. I have tried using =TODAY(), =TODAY, TODAY, TODAY(), but can't get it to bring back today's date (got #INVALID COLUMN VALUE, #UNPARSEABLE or…
