-
Sumif date formula
Hi All After a sumif date formula- have tried a few but think my logic is off Sheet 1 has Date Invoiced Invoiced amount In Sheet 2 I need to sumif {Invoiced Amount} for year and month only - eg will sum all invoiced $$ amounts for the month of may
-
How can I have boxes checked for all distinct employee ID if a payrate = a specific value (0.01)
I currently have a formula that will look at the pay rates for the same Emp ID and if there is a difference, it checks the Attention Pay Rate box in all rows with that Emp ID. This formula is: =IF(COUNT(DISTINCT(COLLECT([Pay Rate]:[Pay Rate], [Emp ID]:[Emp ID], [Emp ID]@row))) > 1, 1, 0) NOW, I have created a helper columnโฆ
-
Formula for checkbox if meets criteria
Hi, I've kind of asked this question before, but the formula that was suggested doesn't work on multiple dates. I have sheet A and Sheet B Sheet A has columns of ID# and Date Sheet B has columns of ID#, Date 1, Date 2, Date 3 etc... The formula I have in sheet B didn't work when there is a different date column in the sameโฆ
-
Send an Update request again is not updated in 1 hour
Hello, I have created an assignment system that shoots an update request to all shared with the sheet for the acceptance of an assignment. I am trying to figure out how to send an update request every hour until someone accepts the assignment. I may add a checkbox column so that users can decline the assignment and in thatโฆ
-
SumIf
I am trying to use the SUMIF Formula to reference a sheet to add hours based on the name of an employee. I have a Names Column with a list of names and an Hours Column. On a second sheet I am trying to print out their hours added together based on their name. My attempt =SUMIF ({HoursCol}, Name@row = {NameColum},โฆ
-
Daily manpower
I am having trouble creating a consistent formula to track how many workers will be on site for a given day. Based on the start, end time, and count of manpower for each task, I have used that as a reference for a SUMIFS() formula in a separate column. I have also added a date column that shows a list in ascending order ofโฆ
-
Index Match using two sheets
ย Hi! I am trying to use Index Match but not having a clear understanding of what it is I need to do is making it difficult.ย All I need to do is when I add the Reference Number, the formula should search sheet A and sheet B for the number and pull 4 columns of data based on this number. What I would like to be able to doโฆ
-
Formula to vlookup Summary Field
Hi ๐๏ธ, Any fornula to lookup a summary field on a smartsheet? Thank you!
-
Count Instances Across Sheets
Part 1. How Many Rows Is there an easy way to count how many times a value in one sheet appears in a column of another sheet? Sheet #1 A cell in a column that is being checked may look like this: Project #1 | ABS 100,ABS 102,CAR 144,ESP 332 Project #2 | ABS 102,SPE 344,SPE 422,STEM 300 Project #3 | AAY 320,ABS 102,SPE 344โฆ
-
If countifs statement not working
Hello and thank you for reviewing my post! My formula is only working when there are no duplicates in my rows but I need it to function even if there is a duplicate. Please see screenshots below. Anytime there is more than one submission for Birmingham in the same month it is not checking the box. There are on occasionโฆ