Formulas
Discussion List
- Hi, I have six sheets with an identical setup. I want to be able to summarize how much Effort each person has been assigned for all the sheets. For example, Bugs Bunny may have 12 hours assigned in Sh…
- Is there a way to have completed tasks in a sheet either obsolete or move to the bottom of sheet after a certain amount of time has passed?
- I believe this is an easy fix, I am just not able to figure it out! I am trying to change my formula so that the status icon does not change to red only once it is in progress for tasks due today. I w…
- I want a calculation to run if a cell value is within a range. IF Cell X is between 1-4, THEN sum(cellZ, cellP, cellH) How do I write this?
- Hello everyone, I have a fairly large sheet (~5000 rows). I have one column whose value gets changed based on data from another column within the sheet. The source column is a country code column and …
- Hi all, I am creating a text summary that pulls numbers from other columns. It's for the results of a ballot, so I want it to look like this: 2 approve, 4 reject, 5 abstain And the formula looks like …
- Hello friends! I am creating a log which tracks the life of tickets we open. When we change the assignment group or status of the ticket, I would like for a new row to be automatically be created, pre…
- Hello, Im trying to create a column formula that when a user selects a certain field, the responses will automatically go to a specific person/responder and will notify them of a task that's awaiting …
- Good afternoon, I'm looking for help with my budget sheet. I need to calculate the project design cost using a rate, but when we have a change order the rate can be different. As an example for the fi…
- Hello - I am trying to count something if it meets the criteria and running into an Invalid operation error. What I want to do: If the priority in another sheet is NOT "N/A", Count the status in anoth…
