Formulas
Discussion List
- Hi all, I can't understand why this simple calculation isn't working, or if it's my brain! I am trying to calculate in the highlighted cell, 29 * 73,000 Euro each time it returns zero. The 29 is a for…
- I am stuck with an "Incorrect Argument Set" error when I try to use VLOOKUP. On Sheet 1, I have a column called "User Name." I am adding a helper column tacked onto the right side of a large timesheet…
- I have a formula I need help with for the top level of my project checklist hierarchy. Overall Project Status - this is looking only at the highest level rows which are indicated by the helper column …
- Hi, I am trying to write a formula that will pick the right data to automatically fill the Actuals - Monthly cell (Row 11 in the description column). I have tried an INDEX MATCH formula (=INDEX([M1 20…
- GSheets and Excel have these formulae as standard. It would be useful to have the ability to use RegEx to parse through strings.
- Hi! I need some help getting a formula to work for a sheet summary and have confused myself at this point. I need to get a sum of the reach our national events collected within Q1. Columns: National_l…
- Hello, I would like to sum up costs only for cells that have multiple homegrown fruits within a single month. In this example, January's sum would be $3,500. I've tried a few formulas and thought I go…
- I have a column in my grid that generates the Task number automatically for Level 2 and all of the children below it. IE if I choose the drop down "Task 1" for a row that is level 2 then that row and …
- I need a formula that populates the due date based on the date that its approved. I want the date to be at the end of each quarter
- With so many posts about this why has this feature not been added or fixed? The fact that this is not a feature in Smartsheet makes it extremely difficult and inefficient to accurately determine sched…