-
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,…
-
Combining Text and Formula Into Same Cell
Hello all - I am trying to imbed a text string into a formula (using the NETDAYS() function). The end result would be something similar to: "Number of days between Kick off Meeting and Final submittal is [RESULT]". I am able to use the formula in a standalone cell with no text. In an adjacent cell, I am able to create a…
-
Can I give the RYGB Balls column "Status" a default colour when a new row is added to the sheet?
I think my question speaks for itself. The RYGB balls type has 4 coloured balls. Which I'm using as follows. Blue = "New task" Green = "Active task" Red = "Finished task" Yellow = I'm not using this one. So what I want is for a new row in the sheet, is for this column to automatically turn "Blue" to indicate a new task. It…
-
Formula on data from web form
I'm using a web form for a costume contest to be able to have people sign up. Due to the rules, they must be at least 18 years old to compete. I have a formula to display the person's age based off of the current date, but I want this to auto-populate when they submit from the form. Is there a way to do this?
