-
Error calculating time
I believe I have read through every thread on this topic and it has been extremely helpful. However I'm getting a weird error that hopefully someone can help me with. I'm getting a completion time of "10:05 04pm" in row 3, I'm sure this is due to the amount of time for the task - I just don't know how to write this so this…
-
Availability Formula
I/m actually using this formula to check the current week availability of the employees considering all the jobs' dates of the year in which they are involved: =IF(AND(WEEKNUMBER([Start Date]3:[Start Date]11) = WEEKNUMBER(TODAY()), WEEKNUMBER([End Date]3:[End Date]11) = WEEKNUMBER(TODAY())), "not available", "available")…
-
Using multiple IF statements with SUMIF
Hello, I am trying to nest IF statements, and for each true IF statement I want to use SUMIF to get the totals for a specific value. Code below if giving me an unparseable error. Could anyone help me figure out why it won't parse? =IF([List Item or Activity]@row = "Plan Total", SUMIF(Phase:Phase, "Plan", [Total…
-
Index/Match using two criterias
I'm trying to see if I can use index/match with two criteria's. First criteria being the name, and the second the month. So far I am using this: What would be the best way to match Operator Name & Month? I am referencing another sheet that has Name & Month as well, followed by the summary. This seems to be the formula!…
-
COUNTIFs if Column contains multiple values
Hi all, I have a Form that users submit when an Error is detected made throughout the business. As part of this, they select what department(s) make the error. Which inputs multiple values into the cell. e.g. Artworks, Production etc. I'm trying to count the number of errors per department using a CountIF formula. (I also…
-
How to count 'blank' cells in a column.
Hello, I am trying to count the blank cells in a column and i'm using the ISBLANK formula. however it keeps saying INCORRECT ARGUMENT. the formula works with every other status in the column in my reference sheet but doesn' count the blanks. Please help! this is the formula im using: =ISBLANK({TEMPO TRADE WORK TRACKING…
-
Using COUNTIFS with multiple criteria and OR
Hi, I'm trying to count the number of rows that meet the following criteria (I'm getting an "Incorrect Argument" error. Project Complete is not checked Project Cancelled is not checked Sales & Leads is not checked Month is August Year is 2022 Deployment Type is either New Deployment or Package Upgrade =COUNTIFS({Project…
-
Function to combine different dates
Hi, I am working with timecard data, and trying to find a way to show how many days someone called out for a specific reason. The problem is that there are sometimes multiple rows per day. It looks similar to the table below (blank spaces are worked hours). For example, if I wanted to know how many days Bob had FMLA, it…
-
Report to show last data entry only
Good morning, I am looking for a report to return a column value from the last sheet data entry. Essentially, I would like to create a dashboard that tells me whether my machine is online or offline based on the data that the operator puts into the highlighted column. I'm guessing that generating a report would be the best…
-
Project Settings Timeline Display for Gantt Chart : mm/ss
Has a solution been created yet to display a Gantt chart in minutes and seconds and to reduce the unit of time for start and finish to minutes and seconds. I would love to create a mfg process flow in smartsheets, but the current unit of time does not permit that.
