-
Is there a way to record who checked a box
I have a sheet that I would like a sup to check the box if they approve the of the data in that row. Is there a way to record via contact list who marked that check box?
-
Need help for a correct formula...
Hi, I need to fetch the data from monthly operating rate of currency in which i have diffrent currencies. i have some monthly fixed exchnage rates agnist the USD. so i need a perfect formula to get the exact currency exchange rate for the specific month according to month + year for my main sheet from another forex…
-
TOTALFLOAT to set drop dead date?
I added a column in my project template that calculates TOTALFLOAT and was hoping to use that value to set a drop dead date for myself to reference. Basically =[End Date]@row + [Days Item Can Be Delayed]@row. The second column in the formula is where TOTALFLOAT formula lives. But this outputs the same date as the end date,…
-
Formula results started flipping back and forth
Hello, My team has been using the sheet I built for months, and on or around 9/12, some of the formulas have gone haywire. I have multiple components within a project, and once all components are complete, the project stage will flip to Complete. I use a JOIN(COLLECT) function in one column and a helper column that…
-
If statement for a Modified Date column WITH the time in the cell
Hello again community! I am trying to write a if statement formula where if a certain cell in the sheet is blank it will show the modified date column. Below is the sample of the formula: =IF(NOT(ISBLANK([Sample]@row)), Modified_date@row,"") This formula works great when I set the column formula to a Date column. However,…
-
Task Duration Increase
Is a task duration is 20 days and it is increased by 3 times to 60 days for example, is there a way for this to be shown in a report or sheet?
-
IF formula with AND OR nested
Hello, I'm attempting to create a formula that will determine if one or both options have been selected in a dropdown and assign that a numerical value. What I have now is =IF(OR([Communications provider]@row = "Provider A", [Communications provider]@row = "Provider B", AND([Communications provider]@row = "Provider A",…
-
What do these formulas mean?
A metrics sheet was designed for my group with the following formulas embedded in the cells. I understand all except the $10. The reference links to the status column of a tracking sheet along with the program manager's name. Also, this formula links back to the same sheet. Any assistance you can provide is appreciated!
-
SUMIFS with multiple criterion
Hi there, I am running the current formula... =SUMIFS({Sales Range 1}, {Sales Range 2}, [Primary Column]$21, {Sales Range 3}, [Primary Column]@row) ...This formula has a reference point of a sales persons name at "[Primary Column]$21" and the month I want to measure as "[Primary Column]@row". Now I am trying to run this…
-
Date format - Cell linking
Hi, When I try to cell link a date column it changed the date format from: dd/mm/yy to mm/dd/yy. The strangest thing is that it did not happen most of the rows, but some random ones. I have tried to refresh the sheet several times, but I still get the same date errors. Do anyone have any idea or suggestions in order to fix…