-
Trying to get OR to work with Countifs
First part of Countifs works, cannot get OR to work. Want to count everything that is before today that is Current State ="In Queue" or "In Process". Current error I get is invalid operation. Have tried multiple iterations without luck. What am I missing? Thanks! =COUNTIFS({CNC, CMM, and BL Request Sheet Need by date},…
-
Compare duplicate rows, identify most recently added
I have a form that brings in graduate student information (ID, name, office, start & end dates, etc). Sometimes the form brings in duplicate information as the student's end date is extended. I'd like to identify the oldest added duplicate to the sheet so that I can create a workflow to move it to my archive sheet. Thank…
-
Combining Not Contains and Contains into the same formula
hi Team, The below formula. I am trying to combine these validations into one statement. If any of them are true, the row should flag as yellow. If any of them are false, it should flag as green. However, the statement is flagging as "green" when "warning records" is not found. It should flag as yellow.…
-
Date formula question
If I have a field with the date of 8/9/2023 and I want to add a column with a formula to find the date for the beginning of that week how would I write it?
-
Formula - convert a name to e-mail address
Hi all, I am looking to convert a name to a e-mail address using a formula. This is the example: convert 'Andreas Johnson' to 'Andreas.Johnson@company.net'
-
Creating an 'overflow' semicircle donut chart
I'm trying to create a semicircle donut chart in the dashboard to show how much the team overspent towards a budget. For example, the budget is $100 per month but the team spent $150. Is there a way of creating an 'overflow' semicircle donut chart that shows the extra? Instead of showing a full semicircle donut chart for…
-
Merging Rows
Hi All, Is it possible to merge the data in 2 or more rows in a grid sheet together? Case: At our production facility, once a shift (12hr) we have forms that operational staff fill out that gathers all the information required for that shift into the same sheet. We then run reports with filters etc. to extract the…
-
Timestamp
Hi Team, I have looked on here with no luck so far. I may be using the wrong search terms. I want to subtract one timestamp from another to get the hours worked on-site for the day. Is this possible? Thank you Chris
-
Project Variance Formula Using Levels
I need help with a formula that calculates variance between actual durations and planned durations set at the start. We frequently need to reset the baseline throughout a 3-5 year project, and I would like a historical record of where we started and where we ended, without having to copy/paste current baselines before they…
-
SumIFS from another sheet with two conditions
I am trying to use the SUMIFS function to sum the total budget approved for one of the Functions when the STEP is only In-Flight. This is the formula I am using, but it's not working! =SUMIFS({Projects Function}, CONTAINS("Finance"), {Projects Step}, CONTAINS("6 - In Flight"), {Budget}, >25) I need the data from another…
