-
Average % complete if task is assigned to "xxx"
What I am trying to do is figure out an assigned user's bandwidth. I am doing this by having them assign a % Complete to a task and then averaging the children =AVG(CHILDREN()). What I want to be able to do is average the children but only for specific assigned users. So average the children (% Complete) for tasks assigned…
-
Formula Column - Change Status based on %Complete
I have created a Column called Formula1 and I am wanting to use this column to create a formula that will look at the %Complete and If the %Complete = 100% (1) then change the status to Complete. Currently I have the following as the formula: =IF(%Complete1 = 1, Status1 = "Complete") Problem is I am getting "#NUMBER…
-
Getting the most recent item in a column
I am trying to create a project status entry form that keeps a running log of updates - and I want to take the most recent update and roll it up to a summary report. The data sheet looks like this: (attached) Line 1 is the summary line that will link to a master scorecard elsewhere. The value of [Report Month] on line 1 is…
-
function dates difference
Hello there! I am trying the function =TODAY() - [starting date]3 and I am receiving this number as result: 86.7854 how can I obtain jus a round number of days?
-
Connecting two formulas
I have 2 formulas that both work. I want to merge them into one formula but it is not working. =IF((COUNT(CHILDREN(Availability5)) = COUNTIF(CHILDREN(), "Red"), "Red", "Green" =IF((COUNT(CHILDREN(Availability5)) = COUNTIF(CHILDREN(), "Gray"), "Gray", "Green" It might just be time for lunch but what are the rules to putting…
-
Virtual Time Cards - Contractors Working Remotely - Timecards
We manage a group of independent contractors that work off site. We are looking for a design of a web form so they can record the hours worked daily. This would have to allow for start time, lunch time (punch out), lunch time (punch in), and end time. Looking for a formula to calculate the hours worked daily, weekly, and…
-
Multiple Sheets - SUM Dollar Totals in Report
I did a quick search in the community and didn't see this answered exactly, but i think either an Excel export or a future release of Dashboards may provide a quicker/better solution. So here's what I'm trying to solve. I've got 10 sheets that track Paid Claims. When the Claim is paid, a field titled "Date Payment Received…
-
Access to attachment meta-data?
My team is looking for a way to rapidly view information about attachments (title, date/time of last modification), without having to actually open the attachment window. I don't see any way to do this currently. Some suggestions would be: * 1. System data column type to report last modification of attachment(s). There is…
-
Drop down column based on previous response in web forms
I am looking at creating field in webform in such a way that, the number of columns are based on the response given earlier. For example, if 1st input asks for number of devices, I want that many number of columns to show up for taking in values for that many devices.
-
I need to build a formula that looks at some cells in a column but not all of them.
Hi everyone, I'm trying build a formula that looks at a column of check boxes, and if certain boxes are checked off, it will give me a "green light". Here is the formula that currently works: =IF(COUNTIF(Completed13:Completed26, 0) > 0.5, "Red", "Green") It compiles all the check boxes in my column from row 13 to 26,…