-
Way to have multiple people claim an item
Hello. I have a sheet that shows available material that our workers can "claim". I have a formula that populates the Available Quantity after a number is entered into the Quantity Claimed column. I am looking for a way to have multiple people be able to claim an item if there is Available Quantity left, as well as put…
-
Formula Syntax Error
I am trying to convert a column to a formula, but I am getting the Syntax error and it doesn't convert. The formula appears to work when in the cell and when dragged down, just not when I made it a column formula. Could you let me know what is wrong with it? =IF(AND(ISERROR(Transmitted1), [Hours - Total Timecard Hours]1 =…
-
IF AND NOT CONTAINS
I am trying to create a category of time clocks using the info in a comments section. The Comments are as follows: IT31 Bio (suprema) DeviceID: US2509-1 AssistIT: IWA70 MAC: 0001ce0199ea IP:DHCP Timezone: ET Netinstall ID: 200735 Netinstall PIN: 2735 Punch Scheme: IN, OUT, INL, CBI --- I'm hoping for these results…
-
COUNTIF Formula to Count Months Between Dates
I am new Smartsheet user and I'm working to convert some Excel files we use over to Smartsheet. I need to count the number of months an employee has been employed based on their Hire Date but if they have a Term Date the count should stop at that date. This is the Excel formula I am replacing (I didn't write this):…
-
Countif completed last week
I am trying to write a formula that shows volume of work completed last week. I am getting a result, however it is not grabbing the full list of data. I have played around with different day ranges but it doesn't seem to change my result. The formula I have references other sheets. Please see attached images. I have added…
-
SUMIFS AND CONTAINS
I'm trying to sum the quantity column for all rows where the JO's match and the PN's match. What am I doing wrong, it returns a 0? Here's the formula: =SUMIFS(Quantity:Quantity, JO:JO, AND(CONTAINS(JO@row, @cell)), PN:PN, AND(CONTAINS(PN@row, @cell)))
-
Collecting a date value if not blank
I am trying to combine two columns into one. The only way I can think of doing this is with an IF formula. what I have is =IF([Ready for Final Review Initial]@row = 0, [Ready for Final Review Reapp]@row, [Ready for Final Review Initial]@row) It works for collecting my secondary value, but does not work for the initial…
-
populating one cell (selecting from drop-down options) based on content of another cell in sheet
Hi there, first question posted on the Smartsheet Community, here we go... I'm trying to work out a formula/solution for automatically populating a cell (from a drop-down containing 5 geographic location options) based on the first three characters of a postcode (zip code) in another column (approx 150 postcodes). For…
-
IF OR Question
I'm trying to calculate a Total Amount column where if the Type field is either Faculty or EMT then the Total Amount equals Total Meals * 100 (each meal costs $100), but otherwise is $0. I keep getting errors with this: =IF(OR(Type@row, "Faculty", Type@row, "EMT", [Total Meals]@row * 100, 0))
-
Count within last 30 days if a specified value
Hi! Could someone offer me some help with my formula below please? I need to count how many rows have a date within the last 30 days in column 'Timestamp', and have a value above 8 in column 'NPS', and have a certain name in column 'Centre': =COUNTIFS({Feedback mastersheet Range 1}, <=TODAY(30), {Feedback mastersheet Range…
