Formulas
Discussion List
- We have a sheet that lists all of our projects (there are over 300 at the moment). We used to keep all of our metrics at the top of the sheet, but every now and again, someone would sort by a value th…
- Is there any way to work around dependencies in columns when entering in formulas?
- Trying to find the right formula to count a name column in one sheet based on a specific location in another column. I've done this successfully with numbers using sumif, but the count isn't working. …
- Hi I have a column with a long URL http://blblblblbl... There are about 300 rows in the sheet. I'd like to change the display text of the links to Preview for all of them. Is there a way? I can not do…
- Good day! I am trying to reference one cell in my spreadsheet that has a drop down list of 30+ people in the list. I want to create another cell using the if then formula to say if person a, person, c…
- Hello How do I get rid of a previous check when a new checkbox is selected? This is what really need to happen: (Task Name 6 needs to transition from one to another (Idea, Concept, Design, Validation,…
- Hi, can someone help me on the correct formula that I should use? I wanted to get the number of projects based on their status however the countif formula that I am trying to use doesn't work in Smars…
- I am updating information on to a sheet when I contact our customers AP dept either by email or Phone. The info I update includes Invoice- date- AP response. I want to use this data to link to another…
- I am having a bit of trouble figuring out how to write a formula to automate RYG symbols. Basically I want the rules to be as follows: 1. If value is less than 4, RED 2. If value is greater than 4 but…
- Hello, I have several Tasks. I want a formula that moves the whole row of a task, upon it's completion, to the bottom of the task list. Thank you for your help, Sohlbe
