Formulas
Discussion List
- I am trying to put a formula together to say if there is a date, list it here (On-Site Training), if it says no match, then don't do anything.
- Can a formula contain a reference to a checkbox cell and then return a result based on if that box is checked or unchecked?
- A component is adamant about tracking their actual time on projects based on percentage of an 8-hour workday, but senior managers want to see actuals based on hours. Is there a formula or other way fo…
- Using the formula below to pull references from two sheets. I am getting data returned from the first sheet, but not the second. When I reverse the order of the references the formula works the other …
- Hello, I need help with a formula combing average, value, collect, and contains. I am trying to pull data from another sheet pulling out just the values from the selected options (options are 4 - Comp…
- Hi folks, I have a Debt total in a cell on my budget spreadsheet (e.g. 7000); I have a row of payments by month (e.g. 160). I want to subtract each new cell of payment of 160 from the total cell of 70…
- Hello, Currently I'm struggling to add <= value to my current formula code, my idea is to count for Order Numbers (Unique values) and Lines of Order Numbers of certain times. since filter doesn't work…
- Hi all We are experiencing strange behavior of cross-sheet references with status showing something we haven't seen before and doesn't appear to be documented: 'Not Shared' or 'Circular'. Also - recen…
- Hello, How may I find the SUM of multiple columns by using the SUM function and RIGHT function? I am collecting the data via a Smartsheet form and will need to email out the call center representative…
- Good afternoon! I attempted to use this template to create a multiple cross-sheet reference VLOOKUP. It works for the first three sheets but everything after the first three makes the formula unparsea…
