-
Forumla help: pull over number based on date
@Paul Newcome Hey Paul, reaching out for your help again. I've got a field log sheet that I'm hoping to automate. I've figured out how to count the number of panels erected automatically, but now I can't figure out the number of men column. The number of men/day stays here's a published sheet. The challenge is it's not…
-
Formula Not Working. Turning Sizes into Numbers
Hello, I am trying to write a simple formula where I translate a size value into a number. For example in my column called "Size": I want to create a formula that turns the following size into corresponding numbers in another column. XS = 1, S = 2, M = 3, L = 5 My formula is as follows, but doesn't work? =IF([Size]1 =…
-
Disabling Field Logic?
Hello Community, I am sure this is an easy task but for the life of me l can't make it happen. I setup some field logic to make the user enter a date only after the condition was met, since this is a new process and user is still catching up with entering the data, we decided to disabled this logic so they can just fill…
-
Counting number of new rows using Created (Date) and resetting each week
Has anyone posted a formula to use that counts the number of new rows added to a sheet based on the system generated create date? I want to do this and have it reset the count each week, perferrably each Monday. I want to: "Look in the Created (Date) column of Sheet 1 and count if the date [that this row was added] is…
-
IF statement based on expiration dates
Hello, I am new to smartsheet. I am trying to set up an IF statement for a due date. My team has required training that expires on an annual or bi-annual basis. I am trying to make an IF statement in my Health Column based on their last completion date. So if they last finished the training on 06/30/19, I want the health…
-
Countifs that aren't certain status and are within specific time frame
I want the formula to show how many items are assigned in the next two weeks that also are not marked Complete, Cancelled, or Hold. When I use the first part of the formula on its own it works, but I want it to show only those within the next two weeks. =COUNTIFS(Status:Status, NOT(OR(@cell = "Complete", @cell =…
-
Join Collect Function not working
Hello! I have this formula and it doesn't seem to work: =JOIN(COLLECT([Capacity-Space Planning]2:[Capacity-Space Planning]245, [Property Name]2:[Property Name]245, [Property Name]@row, Space2:Space245, Space@row)) I'm not sure what I'm doing wring, it's not bring back anything. Help!
-
Copy Rows Workflow
Hi, I want a sheet to copy all new rows from one sheet to another master sheet but my original sheet has an Auto-Number/System column in to give every row a reference number, when the workflow runs it creates a whole new column at the end of the data because it won't allow me to have the column it should go to in the…
-
Risk Management Formula
I have two columns named Probability and Occurrence. Both the columns has a closed list. User have to select from Very Low (1), Low (2), Medium (3), High (4) and Very High (5). When the users select medium from one column and high from the second column then the third column should multiply the 3 x 4 = 12. The third column…
-
SUMIFS and Referencing Another Sheet (Financials) = INCORRECT ARGUMENT SET
Hello all, I'm trying to compile some financial totals for various departments into a Metrics sheet for Dashboard reporting and something is not going right. I can get the total for all departments from the referenced sheet with =SUMIF({Total}, but when I add the criteria for each department I get # INCORRECT ARGUMENT SET.…