-
Budget v. Invoice Cost Codes
I have two Smartsheets. Sheet 1 is my budget broken down into various cost codes. Sheet 2 is a log of all my invoices with cost codes and amounts assigned to each invoice. I am trying to take the amount from each invoice and have them populate in my budget according to their cost codes. The budget amounts for each cost…
-
how to calculate how many staff are on site each hour?
Because of Covid, we need to know the max number of staff that are at the worksite each hour. When I had a "fixed" time frame for everyone, the formula was easy and made sense. Example, when everyone had 8:00 to 10:00 shifts and 10:00 to 12:00 shifts. But now I have random shifts and I don't know what formula I can use to…
-
Error w/ Formula (#INVALID)
Hi Formula Friends - Can you help me identify what's going wrong with the following formula (Reference Cell: 'Count1'): =COUNTIFS([Work Related Exp]:[Work Related Exp], 1, Created:Created, AND(DATEONLY(@cell) >= [Encounter Date]$2, DATEONLY(@cell) <= [Date Resulted]$2)) I was working a few days ago; however, something…
-
Email / Name reference formula help
Hi, I am trying to create a formula where an entered email address automatically populates the person's name associated with that email in an adjacent column (see below). The data is referenced from a master sheet of people's email/name contact information. I have this function in a different sheet and it works perfectly…
-
Display partial content from a cell
Hello! I am attempting to show part of one cell in another cell. This is the formula I tried but I am getting inconsistent results. I am trying to just show everything after the - in the Author ID column. Where am I going wrong? =IFERROR(RIGHT(Contributor@row, FIND("-", Contributor@row) - 1), "")
-
If/countif returns incorrect arguement
So I'm using the following formula and getting errors. =IF(COUNTIF([ID Dump]:[ID]), "CURRENT", "NEEDS") Basically, I'm trying to get a return of CURRENT if any of the values in the "ID DUMP" column are in the "ID" column, and then a NEEDS if the number in the "ID DUMP" is missing. I used the following formula in excel and…
-
Trouble with COLLECT in INDEX/MATCH
I'm trying to troubleshoot an INDEX/MATCH formula that contains a COLLECT statement which is supposed to limit what cells are being used for the MATCH. I am referencing a project schedule, looking for the "next deliverable" - we have a column called "Function" in which the schedule tasks can be defined as such. (See…
-
Pasting from excel into primary column in smartsheets
this is probably really obvious but why when I manually enter a value into a new row in the primary column all the formulas are replicated to that new row, but if a paste a value in from excel the formulas don't get replicated? many thanks in advance Andy C
-
Calculating hours:minutes from cells with date and time
Trying to calculate total time (preferably in minutes) spent at a task/site. Arrival and departure "times" are written in date-time format - so (arrival) [2/28/19 9:15PM] in one cell/column and (departure) [3/1/19 2:25PM] in another cell/column. If it helps, those cells were created by combining multiple columns - date…
-
Formula (IF Statement?) that checks if row numbered sequentially?
Can I write a formula that could check if rows belonging to same project number have been numbered sequentially? My sheet tracks several projects and each project could have several entries on one sheet and these must be numbered so we know how many submissions were made per project. I wrote one to check for duplicates…