-
I am trying to substract time and the value is comming back only in positive
here is my formula =SUM(TIME([Time Scheduled ]@row) - TIME([Time Finish Load/Unload]@row)) and here is my if formula =IF(Difference1 < 0, "Late", "On Time") and i have attached the sheet, i am trying to return the value where i can see late and on time, but my formula is returning back all the numbers in positive even the…
-
Sumifs match @row
We are keeping stats on one sheet named, "2024 STATS..." using SumChild formulas to roll up the daily stats per week, per month, per Doctor in the office. I'm trying to get the combined total for the clinic, for each stat to appear on another Sheet called, "Stats Metrics." To ensure the stats are coming from the correct…
-
If then formula - word in one column = number in another column
Hi working on a work breakdown schedule and need if then qualifiers. Idea is if the word "Design" is in the column "Who Produces the piece? (image below) Automatically add "2" in the duration column in the row that has the copy "execute piece changes" under "task type" column.
-
Blank do not Concatenate
Hello, I have a cell i use to concatenate a varying cells into one line and divides each text by dashes. Currently i'm using =column1@row + "-" column2@ow + "-" +column2@row Is there a way to spin the isblank( or if(blank formula so that if all columns 1 2 or 3 cells are blank it would not use the formula so that the…
-
Bring text to another sheet
Good morning. I am trying to set up some things for my employees. I have a form for them to fill out that includes some goals of theirs and I want those goals to also go onto another sheet as well for me to track those goals for them. Is there a formula that can do this? Thanks for all help.
-
Find first blank in other column and return value in same column
At the top of the Milestones column, I would like SS to return the next task that does not have a date in the neighboring Date column. I've tried a few things, but cannot figure out the correct formula to do this.
-
Counting weeks in a cycle
I need help with a formula to count weeks in a cycle. The cycle start date was 5/1/23. End cycle will be 4/30/24 for example. So I need to display the current week in the cycle as of today. I don't use the today function because it does not update unless the sheet is opened. So instead of the today function I have a helper…
-
Help with text formula based on date range
I'm trying to create a formula that essentially does this: If [Due Date]@row occurs next week then "Next Week" ELSEIF [Due Date]@row occurs last week then "Last Week" I was initially doing this with WEEKNUMBER, but that doesn't work when today and due date are in different years. I then tried doing date math by comparing…
-
setting up linking
Newbie here working on building a crop plan for my homestead, but don't think i'm setting this up correctly in Smartsheet. So far, I've got a sheet called "crop info". This has stuff for my main crop list so name of crop, weeks in greenhouse, number of plantings, etc. This is kind of like my more general goals for the…
-
Status with Predecessor
Hey All, Need help with a formula. What I have works, but I want to add another condition to it though I am not sure how. I do not want the status to show as ready unless the predecessor is complete. I'd like a copy/paste formula vs referencing to a specific row. Thoughts? Here is the current formula =IF(AND([%…