-
Project automatic counter
Hi, im working on project tracker, and i have to do the automatic number assigner for the particular projects. So there is like 20 projects that started in 2020, like 10 in 2019 and each should have number like 1_20, 2_20, 3_20 and when there's start date in 2019 there should be separate count 1_19, 2_19 and so on. Is…
-
Weekly snapshot of related sheet info
I have an Issues sheet that lists all issues raised during a project, when they are raised and when closed. It has a checkbox column that is checked when these issues need to be visible in a weekly report, which will of course change from week to week. There is also a Weekly Report sheet that the Project Manager adds a row…
-
Tick a checkbox when cell contains certain text
Hi, I am wanting my checkbox to be checked if a column contains specific text (i.e. "mothers Day") on that same row. Can someone please help? thanks
-
Avoiding negative values after past date
Hello, I want to display a countdown of the number of days remaining to return to work based on the scheduled day the 'leave ends'. I am using the following formula which works except that a negative value populates after the leave has passed: =[Leave Ends]@row - TODAY() How can I avoid getting a negative value and instead…
-
Formula IF Statement
I am trying to get the Cleaning Progress to Show "In Progress" when the #Days are greater than 1 but if the Cleaning End Date is populated to return "Complete"
-
2 variable function in a formula
Hello! I have 2 variables that determine what the returning value is. First variable would be Name (row), second variable would be Score (column header). The Score value in the formula is a variable and is determined by data entry. For instance, if the score@row value is 99 it needs to find the column 99, if the score@row…
-
I would like to have my formula simplify. I am not great with adding and/or to my formulas.
=COUNTIFS({COLLECT PLANT EXHANGE TEMPLATE ENTER STUDY}, [STUDY NUMBER]@row, {COLLECT PLANT EXHANGE TEMPLATE ROOM}, [ALL COPY]@row, {COLLECT PLANT EXHANGE TEMPLATE Range 5}, [REF DATE]@row, {COLLECT PLANT EXHANGE TEMPLATE TYPE 1}, [TYPE OF PLANT 3]@row) + COUNTIFS({COLLECT PLANT EXHANGE TEMPLATE ENTER STUDY}, [STUDY…
-
IF(AND(OR Statement Help
I want to write a statement to determine if a record was extended on time? I have a calculated column that determines if a record extension is required [Extension Required] , and the responses are Yes or No. I also have columns for the record [Due Date], and the [Extension Approval Date] Logic: If the value in the…
-
How to include an if statement
I have a vlookup formula. =VLOOKUP([Attribute Name]@row, {Standards List - Enhanced - Business Rules Range 1}, 4, false) . I need to be able to use this formula and check another column based on the version number. I need it to pull in x if it matches the name and version number.
-
Assign a score for a GPA
I need a formula that says, IF GPA column less than 3.0 assign a 0, if it is 3.0 - 3.49 assign 2 pts, if it is 3.5 - 3.89 assign 3 pts and if 3.9 - 4.0 assign 4 pts The formula I'm using is, =IF(GPA@row, <3, 0, =IF(GPA@row, =3 - 3.49, 2, =IF(GPA@row, =3.5 - 3.89, 3, IF(GPA@row, =3.9 - 4, 4)))) Thanks for the help.